Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,701–3,725 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3701 | 3003701282875 | 2026 |
| 3702 | 3003702737136 | 2027 |
| 3703 | 3003703136408 | 2028 |
| 3704 | 3003704144719 | 2028 |
| 3705 | 3003705298181 | 2028 |
| 3706 | 3003706933149 | 2028 |
| 3707 | 3003707734120 | 2028 |
| 3708 | 3003708268371 | 2032 |
| 3709 | 3003709103739 | 2032 |
| 3710 | 3003710982472 | 2032 |
| 3711 | 3003711858264 | 2033 |
| 3712 | 3003712267524 | 2034 |
| 3713 | 3003713058104 | 2034 |
| 3714 | 3003714093778 | 2035 |
| 3715 | 3003715177382 | 2035 |
| 3716 | 3003716023803 | 2035 |
| 3717 | 3003717488707 | 2035 |
| 3718 | 3003718034270 | 2036 |
| 3719 | 3003719954751 | 2036 |
| 3720 | 3003720784456 | 2037 |
| 3721 | 3003721664925 | 2038 |
| 3722 | 3003722888760 | 2038 |
| 3723 | 3003723054499 | 2040 |
| 3724 | 3003724107869 | 2040 |
| 3725 | 3003725176609 | 2043 |
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;