Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,126–3,150 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3126 | 3003126658086 | 1754 |
| 3127 | 3003127070582 | 1754 |
| 3128 | 3003128873677 | 1754 |
| 3129 | 3003129050074 | 1754 |
| 3130 | 3003130344032 | 1754 |
| 3131 | 3003131343009 | 1754 |
| 3132 | 3003132865534 | 1754 |
| 3133 | 3003133612798 | 1754 |
| 3134 | 3003134944369 | 1754 |
| 3135 | 3003135973648 | 1754 |
| 3136 | 3003136732390 | 1754 |
| 3137 | 3003137505361 | 1756 |
| 3138 | 3003138726051 | 1757 |
| 3139 | 3003139824813 | 1757 |
| 3140 | 3003140838650 | 1757 |
| 3141 | 3003141038352 | 1757 |
| 3142 | 3003142262723 | 1757 |
| 3143 | 3003143316648 | 1758 |
| 3144 | 3003144812231 | 1759 |
| 3145 | 3003145837451 | 1761 |
| 3146 | 3003146558391 | 1761 |
| 3147 | 3003147677959 | 1761 |
| 3148 | 3003148531584 | 1761 |
| 3149 | 3003149338160 | 1763 |
| 3150 | 3003150275242 | 1764 |
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;