Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,026–6,050 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6026 | 3006026427584 | 3324 |
| 6027 | 3006027505540 | 3324 |
| 6028 | 3006028203819 | 3325 |
| 6029 | 3006029133665 | 3326 |
| 6030 | 3006030331727 | 3326 |
| 6031 | 3006031519652 | 3326 |
| 6032 | 3006032723930 | 3328 |
| 6033 | 3006033195980 | 3328 |
| 6034 | 3006034193773 | 3328 |
| 6035 | 3006035158949 | 3328 |
| 6036 | 3006036078606 | 3328 |
| 6037 | 3006037234604 | 3330 |
| 6038 | 3006038633006 | 3330 |
| 6039 | 3006039068357 | 3330 |
| 6040 | 3006040880312 | 3330 |
| 6041 | 3006041744336 | 3330 |
| 6042 | 3006042724617 | 3331 |
| 6043 | 3006043478281 | 3334 |
| 6044 | 3006044521668 | 3334 |
| 6045 | 3006045854392 | 3335 |
| 6046 | 3006046299057 | 3337 |
| 6047 | 3006047430675 | 3338 |
| 6048 | 3006048848571 | 3338 |
| 6049 | 3006049070500 | 3339 |
| 6050 | 3006050863060 | 3341 |
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;