Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,226–5,250 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5226 | 3005226890785 | 2870 |
| 5227 | 3005227392179 | 2870 |
| 5228 | 3005228292082 | 2870 |
| 5229 | 3005229081620 | 2871 |
| 5230 | 3005230486158 | 2873 |
| 5231 | 3005231317139 | 2873 |
| 5232 | 3005232223681 | 2874 |
| 5233 | 3005233914641 | 2874 |
| 5234 | 3005234579377 | 2874 |
| 5235 | 3005235796328 | 2875 |
| 5236 | 3005236958881 | 2875 |
| 5237 | 3005237553559 | 2879 |
| 5238 | 3005238477342 | 2880 |
| 5239 | 3005239717178 | 2880 |
| 5240 | 3005240434518 | 2880 |
| 5241 | 3005241106566 | 2883 |
| 5242 | 3005242121814 | 2888 |
| 5243 | 3005243936327 | 2888 |
| 5244 | 3005244361090 | 2890 |
| 5245 | 3005245428184 | 2892 |
| 5246 | 3005246418063 | 2892 |
| 5247 | 3005247168207 | 2895 |
| 5248 | 3005248287107 | 2897 |
| 5249 | 3005249585977 | 2897 |
| 5250 | 3005250811410 | 2899 |
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;