Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 401–425 of 9,842

ticket, page 17 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
401	3000401215630	180
402	3000402973128	180
403	3000403080350	180
404	3000404714762	180
405	3000405695102	180
406	3000406417158	180
407	3000407902456	180
408	3000408901126	180
409	3000409185635	180
410	3000410433774	180
411	3000411744194	180
412	3000412882071	180
413	3000413171907	180
414	3000414454285	180
415	3000415970610	180
416	3000416268557	180
417	3000417838469	180
418	3000418182863	180
419	3000419162293	180
420	3000420686443	183
421	3000421787291	183
422	3000422982101	186
423	3000423099295	188
424	3000424144549	188
425	3000425520136	189

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;