Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,826–5,850 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5826 | 3005826406394 | 3266 |
| 5827 | 3005827039817 | 3266 |
| 5828 | 3005828673892 | 3266 |
| 5829 | 3005829204634 | 3267 |
| 5830 | 3005830075976 | 3267 |
| 5831 | 3005831237468 | 3268 |
| 5832 | 3005832433647 | 3270 |
| 5833 | 3005833893769 | 3270 |
| 5834 | 3005834886960 | 3271 |
| 5835 | 3005835288748 | 3271 |
| 5836 | 3005836448257 | 3271 |
| 5837 | 3005837515753 | 3271 |
| 5838 | 3005838604945 | 3271 |
| 5839 | 3005839732335 | 3271 |
| 5840 | 3005840107590 | 3271 |
| 5841 | 3005841856903 | 3271 |
| 5842 | 3005842021740 | 3271 |
| 5843 | 3005843590290 | 3271 |
| 5844 | 3005844028880 | 3271 |
| 5845 | 3005845562847 | 3271 |
| 5846 | 3005846322580 | 3271 |
| 5847 | 3005847884300 | 3271 |
| 5848 | 3005848937929 | 3271 |
| 5849 | 3005849605854 | 3271 |
| 5850 | 3005850527071 | 3271 |
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;