Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,726–1,750 of 9,842

ticket, page 70 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1726	3001726508453	945
1727	3001727106060	945
1728	3001728585054	945
1729	3001729880916	945
1730	3001730274024	945
1731	3001731938183	945
1732	3001732454200	948
1733	3001733294556	949
1734	3001734224240	949
1735	3001735002552	951
1736	3001736278762	951
1737	3001737305783	953
1738	3001738090314	954
1739	3001739023344	954
1740	3001740108775	954
1741	3001741362510	956
1742	3001742803999	956
1743	3001743026400	958
1744	3001744018963	959
1745	3001745901012	959
1746	3001746181376	959
1747	3001747957605	959
1748	3001748990599	959
1749	3001749321692	960
1750	3001750743832	961

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;