Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,451–3,475 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3451 | 3003451519120 | 1876 |
| 3452 | 3003452367353 | 1876 |
| 3453 | 3003453210712 | 1876 |
| 3454 | 3003454605023 | 1876 |
| 3455 | 3003455018339 | 1876 |
| 3456 | 3003456254163 | 1876 |
| 3457 | 3003457776097 | 1876 |
| 3458 | 3003458508914 | 1876 |
| 3459 | 3003459401679 | 1876 |
| 3460 | 3003460175243 | 1876 |
| 3461 | 3003461155157 | 1876 |
| 3462 | 3003462676367 | 1876 |
| 3463 | 3003463177594 | 1876 |
| 3464 | 3003464513328 | 1876 |
| 3465 | 3003465113478 | 1876 |
| 3466 | 3003466800311 | 1876 |
| 3467 | 3003467256848 | 1876 |
| 3468 | 3003468131538 | 1876 |
| 3469 | 3003469697692 | 1876 |
| 3470 | 3003470556328 | 1876 |
| 3471 | 3003471742209 | 1877 |
| 3472 | 3003472154308 | 1877 |
| 3473 | 3003473839199 | 1878 |
| 3474 | 3003474892521 | 1879 |
| 3475 | 3003475386944 | 1879 |
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;