Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,426–5,450 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5426 | 3005426982944 | 3000 |
| 5427 | 3005427815914 | 3001 |
| 5428 | 3005428952658 | 3002 |
| 5429 | 3005429148211 | 3003 |
| 5430 | 3005430332139 | 3003 |
| 5431 | 3005431469921 | 3004 |
| 5432 | 3005432300561 | 3008 |
| 5433 | 3005433665689 | 3008 |
| 5434 | 3005434136235 | 3008 |
| 5435 | 3005435012279 | 3008 |
| 5436 | 3005436592477 | 3009 |
| 5437 | 3005437149520 | 3010 |
| 5438 | 3005438928756 | 3010 |
| 5439 | 3005439163354 | 3011 |
| 5440 | 3005440717359 | 3011 |
| 5441 | 3005441282087 | 3014 |
| 5442 | 3005442036907 | 3015 |
| 5443 | 3005443393540 | 3016 |
| 5444 | 3005444257401 | 3016 |
| 5445 | 3005445429888 | 3018 |
| 5446 | 3005446808286 | 3018 |
| 5447 | 3005447480376 | 3018 |
| 5448 | 3005448382654 | 3018 |
| 5449 | 3005449452313 | 3018 |
| 5450 | 3005450526178 | 3021 |
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;