Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,801–2,825 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2801 | 3002801764429 | 1573 |
| 2802 | 3002802812415 | 1575 |
| 2803 | 3002803025915 | 1578 |
| 2804 | 3002804985402 | 1579 |
| 2805 | 3002805920584 | 1579 |
| 2806 | 3002806198337 | 1580 |
| 2807 | 3002807436302 | 1581 |
| 2808 | 3002808322523 | 1581 |
| 2809 | 3002809588194 | 1582 |
| 2810 | 3002810607514 | 1582 |
| 2811 | 3002811091558 | 1584 |
| 2812 | 3002812076657 | 1585 |
| 2813 | 3002813038635 | 1588 |
| 2814 | 3002814983316 | 1591 |
| 2815 | 3002815836707 | 1591 |
| 2816 | 3002816156801 | 1592 |
| 2817 | 3002817351985 | 1592 |
| 2818 | 3002818069025 | 1593 |
| 2819 | 3002819618993 | 1595 |
| 2820 | 3002820198446 | 1595 |
| 2821 | 3002821772460 | 1595 |
| 2822 | 3002822911259 | 1596 |
| 2823 | 3002823454215 | 1597 |
| 2824 | 3002824109384 | 1597 |
| 2825 | 3002825484256 | 1597 |
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;