Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,676–1,700 of 9,842

ticket, page 68 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1676	3001676665331	937
1677	3001677883375	937
1678	3001678000710	938
1679	3001679093680	938
1680	3001680569568	938
1681	3001681837416	939
1682	3001682688710	939
1683	3001683291623	942
1684	3001684603642	942
1685	3001685717960	944
1686	3001686312019	945
1687	3001687853144	945
1688	3001688340319	945
1689	3001689591869	945
1690	3001690393825	945
1691	3001691339014	945
1692	3001692932829	945
1693	3001693710140	945
1694	3001694612923	945
1695	3001695306479	945
1696	3001696215202	945
1697	3001697445240	945
1698	3001698400191	945
1699	3001699602449	945
1700	3001700704600	945

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;