Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 8,451–8,475 of 9,842

ticket, page 339 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
8451	3008451358852	4580
8452	3008452947636	4580
8453	3008453423078	4581
8454	3008454201230	4584
8455	3008455710449	4584
8456	3008456019193	4586
8457	3008457298886	4586
8458	3008458035810	4586
8459	3008459715769	4586
8460	3008460772663	4587
8461	3008461505481	4587
8462	3008462756810	4590
8463	3008463881241	4591
8464	3008464437334	4591
8465	3008465180216	4591
8466	3008466853652	4591
8467	3008467205390	4591
8468	3008468982505	4591
8469	3008469650696	4591
8470	3008470027335	4591
8471	3008471675258	4591
8472	3008472120747	4591
8473	3008473089784	4591
8474	3008474005349	4591
8475	3008475315326	4591

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;