Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,651–5,675 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5651 | 3005651876464 | 3143 |
| 5652 | 3005652311162 | 3146 |
| 5653 | 3005653815291 | 3147 |
| 5654 | 3005654270871 | 3147 |
| 5655 | 3005655372204 | 3148 |
| 5656 | 3005656441938 | 3148 |
| 5657 | 3005657606748 | 3149 |
| 5658 | 3005658316674 | 3149 |
| 5659 | 3005659537884 | 3150 |
| 5660 | 3005660449730 | 3150 |
| 5661 | 3005661287571 | 3152 |
| 5662 | 3005662043795 | 3152 |
| 5663 | 3005663889414 | 3156 |
| 5664 | 3005664756334 | 3157 |
| 5665 | 3005665441644 | 3157 |
| 5666 | 3005666432820 | 3157 |
| 5667 | 3005667007059 | 3157 |
| 5668 | 3005668262390 | 3157 |
| 5669 | 3005669240665 | 3158 |
| 5670 | 3005670436858 | 3159 |
| 5671 | 3005671114516 | 3160 |
| 5672 | 3005672532688 | 3160 |
| 5673 | 3005673494432 | 3164 |
| 5674 | 3005674928020 | 3165 |
| 5675 | 3005675881353 | 3165 |
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;