Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,751–5,775 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5751 | 3005751355627 | 3198 |
| 5752 | 3005752760224 | 3198 |
| 5753 | 3005753335283 | 3198 |
| 5754 | 3005754195208 | 3199 |
| 5755 | 3005755393135 | 3199 |
| 5756 | 3005756587774 | 3200 |
| 5757 | 3005757346295 | 3200 |
| 5758 | 3005758167380 | 3203 |
| 5759 | 3005759311303 | 3203 |
| 5760 | 3005760700733 | 3206 |
| 5761 | 3005761581215 | 3206 |
| 5762 | 3005762292443 | 3209 |
| 5763 | 3005763184114 | 3210 |
| 5764 | 3005764553712 | 3211 |
| 5765 | 3005765198580 | 3211 |
| 5766 | 3005766576150 | 3211 |
| 5767 | 3005767228243 | 3211 |
| 5768 | 3005768900786 | 3211 |
| 5769 | 3005769950874 | 3212 |
| 5770 | 3005770498738 | 3212 |
| 5771 | 3005771835468 | 3212 |
| 5772 | 3005772611762 | 3212 |
| 5773 | 3005773049964 | 3213 |
| 5774 | 3005774438216 | 3213 |
| 5775 | 3005775290302 | 3215 |
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;