Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,901–3,925 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3901 | 3003901743019 | 2142 |
| 3902 | 3003902052389 | 2143 |
| 3903 | 3003903680396 | 2143 |
| 3904 | 3003904781710 | 2143 |
| 3905 | 3003905568902 | 2143 |
| 3906 | 3003906253575 | 2144 |
| 3907 | 3003907902141 | 2144 |
| 3908 | 3003908899800 | 2145 |
| 3909 | 3003909363196 | 2145 |
| 3910 | 3003910821076 | 2145 |
| 3911 | 3003911494549 | 2145 |
| 3912 | 3003912090834 | 2146 |
| 3913 | 3003913157374 | 2146 |
| 3914 | 3003914326030 | 2147 |
| 3915 | 3003915516622 | 2148 |
| 3916 | 3003916820615 | 2148 |
| 3917 | 3003917232167 | 2149 |
| 3918 | 3003918464631 | 2149 |
| 3919 | 3003919674823 | 2150 |
| 3920 | 3003920201229 | 2152 |
| 3921 | 3003921256678 | 2152 |
| 3922 | 3003922226531 | 2153 |
| 3923 | 3003923360377 | 2153 |
| 3924 | 3003924699030 | 2154 |
| 3925 | 3003925369878 | 2154 |
Table definition
CREATE TABLE ticket (
ticket_id INTEGER PRIMARY KEY,
barcode TEXT NOT NULL UNIQUE CHECK (length(barcode) = 13 AND barcode NOT GLOB '*[^0-9]*'),
order_id INTEGER NOT NULL REFERENCES purchase_order (order_id)
) STRICT;