Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,651–1,675 of 9,842

ticket, page 67 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1651	3001651082291	921
1652	3001652207441	922
1653	3001653243726	924
1654	3001654226746	924
1655	3001655932354	925
1656	3001656871848	925
1657	3001657534138	927
1658	3001658102952	928
1659	3001659288378	928
1660	3001660641969	930
1661	3001661689721	930
1662	3001662972252	930
1663	3001663445008	930
1664	3001664673765	930
1665	3001665846901	931
1666	3001666059552	931
1667	3001667624584	933
1668	3001668348119	933
1669	3001669517300	933
1670	3001670667094	933
1671	3001671657112	933
1672	3001672024526	934
1673	3001673168082	935
1674	3001674276067	937
1675	3001675614753	937

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;