Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,351–5,375 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5351 | 3005351151010 | 2980 |
| 5352 | 3005352069862 | 2981 |
| 5353 | 3005353257713 | 2982 |
| 5354 | 3005354638820 | 2982 |
| 5355 | 3005355991906 | 2982 |
| 5356 | 3005356129395 | 2982 |
| 5357 | 3005357022175 | 2983 |
| 5358 | 3005358053718 | 2984 |
| 5359 | 3005359649681 | 2985 |
| 5360 | 3005360121140 | 2986 |
| 5361 | 3005361288106 | 2986 |
| 5362 | 3005362700713 | 2987 |
| 5363 | 3005363033778 | 2988 |
| 5364 | 3005364942636 | 2988 |
| 5365 | 3005365056600 | 2990 |
| 5366 | 3005366060320 | 2990 |
| 5367 | 3005367355379 | 2990 |
| 5368 | 3005368489821 | 2990 |
| 5369 | 3005369194914 | 2992 |
| 5370 | 3005370462588 | 2992 |
| 5371 | 3005371782970 | 2993 |
| 5372 | 3005372088205 | 2993 |
| 5373 | 3005373765666 | 2996 |
| 5374 | 3005374108564 | 2996 |
| 5375 | 3005375488050 | 2997 |
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;