Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 376–400 of 9,842

ticket, page 16 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
376	3000376892337	180
377	3000377995816	180
378	3000378469199	180
379	3000379223874	180
380	3000380087570	180
381	3000381770569	180
382	3000382926847	180
383	3000383466598	180
384	3000384972089	180
385	3000385172056	180
386	3000386568797	180
387	3000387273981	180
388	3000388761320	180
389	3000389248053	180
390	3000390367206	180
391	3000391241114	180
392	3000392948336	180
393	3000393654407	180
394	3000394268822	180
395	3000395650133	180
396	3000396372470	180
397	3000397498439	180
398	3000398452546	180
399	3000399994616	180
400	3000400469020	180

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;