Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,826–2,850 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2826 | 3002826789350 | 1600 |
| 2827 | 3002827505297 | 1601 |
| 2828 | 3002828052397 | 1603 |
| 2829 | 3002829234285 | 1603 |
| 2830 | 3002830058034 | 1604 |
| 2831 | 3002831459810 | 1605 |
| 2832 | 3002832336935 | 1605 |
| 2833 | 3002833433286 | 1606 |
| 2834 | 3002834120226 | 1606 |
| 2835 | 3002835457621 | 1606 |
| 2836 | 3002836340155 | 1608 |
| 2837 | 3002837333074 | 1608 |
| 2838 | 3002838753391 | 1608 |
| 2839 | 3002839268678 | 1608 |
| 2840 | 3002840097071 | 1610 |
| 2841 | 3002841463751 | 1611 |
| 2842 | 3002842604545 | 1611 |
| 2843 | 3002843800312 | 1611 |
| 2844 | 3002844649009 | 1611 |
| 2845 | 3002845356857 | 1611 |
| 2846 | 3002846492250 | 1614 |
| 2847 | 3002847963342 | 1614 |
| 2848 | 3002848184800 | 1615 |
| 2849 | 3002849487769 | 1615 |
| 2850 | 3002850779131 | 1615 |
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;