Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,226–1,250 of 9,842

ticket, page 50 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1226	3001226017609	669
1227	3001227339563	669
1228	3001228994817	669
1229	3001229003491	669
1230	3001230346013	669
1231	3001231678741	669
1232	3001232314234	669
1233	3001233930145	669
1234	3001234275262	669
1235	3001235664384	669
1236	3001236419224	669
1237	3001237268583	669
1238	3001238658488	669
1239	3001239203615	669
1240	3001240883518	669
1241	3001241447507	669
1242	3001242333469	669
1243	3001243279022	669
1244	3001244597036	669
1245	3001245507041	669
1246	3001246820604	669
1247	3001247080725	669
1248	3001248526695	669
1249	3001249868746	669
1250	3001250848823	669

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;