Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,801–1,825 of 9,842

ticket, page 73 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1801	3001801204540	1002
1802	3001802677244	1004
1803	3001803464306	1004
1804	3001804665919	1004
1805	3001805951857	1004
1806	3001806090689	1004
1807	3001807375461	1005
1808	3001808369233	1006
1809	3001809573297	1007
1810	3001810936022	1007
1811	3001811249558	1007
1812	3001812660376	1008
1813	3001813032020	1008
1814	3001814073428	1008
1815	3001815450457	1008
1816	3001816475102	1011
1817	3001817274300	1011
1818	3001818073262	1011
1819	3001819370203	1011
1820	3001820294532	1012
1821	3001821458236	1012
1822	3001822066674	1012
1823	3001823841765	1013
1824	3001824204485	1013
1825	3001825228963	1014

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;