Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,501–5,525 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5501 | 3005501143088 | 3056 |
| 5502 | 3005502223031 | 3058 |
| 5503 | 3005503162447 | 3058 |
| 5504 | 3005504922298 | 3060 |
| 5505 | 3005505905492 | 3060 |
| 5506 | 3005506647035 | 3061 |
| 5507 | 3005507138019 | 3061 |
| 5508 | 3005508462690 | 3061 |
| 5509 | 3005509037471 | 3062 |
| 5510 | 3005510807730 | 3062 |
| 5511 | 3005511742462 | 3063 |
| 5512 | 3005512096986 | 3065 |
| 5513 | 3005513132326 | 3069 |
| 5514 | 3005514469893 | 3069 |
| 5515 | 3005515542068 | 3070 |
| 5516 | 3005516496367 | 3070 |
| 5517 | 3005517908888 | 3071 |
| 5518 | 3005518220591 | 3071 |
| 5519 | 3005519552394 | 3073 |
| 5520 | 3005520650806 | 3074 |
| 5521 | 3005521521437 | 3076 |
| 5522 | 3005522551839 | 3078 |
| 5523 | 3005523628161 | 3080 |
| 5524 | 3005524371705 | 3081 |
| 5525 | 3005525989546 | 3083 |
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;