Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,251–1,275 of 9,842

ticket, page 51 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1251	3001251793973	669
1252	3001252623233	669
1253	3001253314399	670
1254	3001254161062	671
1255	3001255718489	673
1256	3001256646848	673
1257	3001257188270	673
1258	3001258229153	673
1259	3001259801822	673
1260	3001260412923	674
1261	3001261521260	675
1262	3001262387141	675
1263	3001263244731	678
1264	3001264127637	678
1265	3001265526366	679
1266	3001266091499	679
1267	3001267274822	680
1268	3001268237531	680
1269	3001269113076	680
1270	3001270847651	680
1271	3001271731370	680
1272	3001272838257	681
1273	3001273135403	681
1274	3001274324569	683
1275	3001275001100	683

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;