Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,301–5,325 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5301 | 3005301517299 | 2938 |
| 5302 | 3005302196157 | 2940 |
| 5303 | 3005303384844 | 2942 |
| 5304 | 3005304208130 | 2942 |
| 5305 | 3005305863589 | 2942 |
| 5306 | 3005306747847 | 2944 |
| 5307 | 3005307270924 | 2945 |
| 5308 | 3005308888649 | 2945 |
| 5309 | 3005309188141 | 2945 |
| 5310 | 3005310000407 | 2946 |
| 5311 | 3005311716835 | 2946 |
| 5312 | 3005312098468 | 2946 |
| 5313 | 3005313147238 | 2947 |
| 5314 | 3005314987814 | 2947 |
| 5315 | 3005315411468 | 2948 |
| 5316 | 3005316514565 | 2951 |
| 5317 | 3005317936993 | 2951 |
| 5318 | 3005318650564 | 2952 |
| 5319 | 3005319578513 | 2953 |
| 5320 | 3005320368149 | 2953 |
| 5321 | 3005321343367 | 2955 |
| 5322 | 3005322343595 | 2956 |
| 5323 | 3005323517824 | 2956 |
| 5324 | 3005324902909 | 2956 |
| 5325 | 3005325122263 | 2956 |
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;