Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 2,051–2,075 of 9,842

ticket, page 83 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
2051	3002051398658	1131
2052	3002052032232	1131
2053	3002053010113	1132
2054	3002054494537	1132
2055	3002055599342	1132
2056	3002056163461	1132
2057	3002057064754	1134
2058	3002058905329	1134
2059	3002059760780	1135
2060	3002060094138	1135
2061	3002061457895	1135
2062	3002062717894	1135
2063	3002063312837	1137
2064	3002064748426	1137
2065	3002065127460	1139
2066	3002066680749	1140
2067	3002067622190	1140
2068	3002068560114	1141
2069	3002069338027	1141
2070	3002070216933	1144
2071	3002071979610	1145
2072	3002072722844	1146
2073	3002073352968	1146
2074	3002074080610	1146
2075	3002075948576	1146

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;