Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 801–825 of 9,842

ticket, page 33 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
801	3000801100393	415
802	3000802936505	415
803	3000803605663	415
804	3000804840817	416
805	3000805387914	418
806	3000806364280	420
807	3000807773375	420
808	3000808423970	421
809	3000809707805	421
810	3000810018654	422
811	3000811353940	422
812	3000812081773	423
813	3000813026518	423
814	3000814634493	424
815	3000815455032	425
816	3000816768413	425
817	3000817302376	426
818	3000818103344	427
819	3000819300099	427
820	3000820075016	427
821	3000821207176	428
822	3000822580722	428
823	3000823472378	429
824	3000824641694	429
825	3000825100620	431

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;