Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,026–7,050 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7026 | 3007026939931 | 3848 |
| 7027 | 3007027698676 | 3849 |
| 7028 | 3007028441036 | 3849 |
| 7029 | 3007029373136 | 3849 |
| 7030 | 3007030442423 | 3850 |
| 7031 | 3007031168578 | 3850 |
| 7032 | 3007032988855 | 3850 |
| 7033 | 3007033760821 | 3850 |
| 7034 | 3007034122851 | 3851 |
| 7035 | 3007035935375 | 3851 |
| 7036 | 3007036452202 | 3852 |
| 7037 | 3007037875723 | 3853 |
| 7038 | 3007038218057 | 3854 |
| 7039 | 3007039282825 | 3854 |
| 7040 | 3007040584605 | 3855 |
| 7041 | 3007041152390 | 3855 |
| 7042 | 3007042696137 | 3856 |
| 7043 | 3007043730983 | 3858 |
| 7044 | 3007044867165 | 3858 |
| 7045 | 3007045886499 | 3858 |
| 7046 | 3007046226393 | 3858 |
| 7047 | 3007047586021 | 3860 |
| 7048 | 3007048867625 | 3861 |
| 7049 | 3007049352936 | 3861 |
| 7050 | 3007050972476 | 3861 |
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;