Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,401–3,425 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3401 | 3003401887103 | 1855 |
| 3402 | 3003402353943 | 1855 |
| 3403 | 3003403880581 | 1856 |
| 3404 | 3003404991451 | 1861 |
| 3405 | 3003405719122 | 1861 |
| 3406 | 3003406298345 | 1862 |
| 3407 | 3003407258785 | 1862 |
| 3408 | 3003408550862 | 1864 |
| 3409 | 3003409606495 | 1864 |
| 3410 | 3003410746671 | 1865 |
| 3411 | 3003411648514 | 1865 |
| 3412 | 3003412015146 | 1866 |
| 3413 | 3003413638001 | 1867 |
| 3414 | 3003414165170 | 1867 |
| 3415 | 3003415575742 | 1869 |
| 3416 | 3003416788844 | 1869 |
| 3417 | 3003417902512 | 1869 |
| 3418 | 3003418658353 | 1869 |
| 3419 | 3003419687159 | 1869 |
| 3420 | 3003420162614 | 1871 |
| 3421 | 3003421475511 | 1871 |
| 3422 | 3003422439201 | 1871 |
| 3423 | 3003423911446 | 1874 |
| 3424 | 3003424423849 | 1875 |
| 3425 | 3003425861223 | 1876 |
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;