Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,151–1,175 of 9,842

ticket, page 47 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1151	3001151672934	642
1152	3001152804454	642
1153	3001153023587	642
1154	3001154368243	642
1155	3001155590305	642
1156	3001156802675	642
1157	3001157145108	642
1158	3001158515976	642
1159	3001159354501	642
1160	3001160904732	642
1161	3001161148932	642
1162	3001162288380	642
1163	3001163907037	642
1164	3001164038605	642
1165	3001165555514	642
1166	3001166072221	642
1167	3001167416602	642
1168	3001168090961	642
1169	3001169361743	642
1170	3001170471121	642
1171	3001171128006	642
1172	3001172499885	642
1173	3001173669706	642
1174	3001174811304	642
1175	3001175319739	643

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;