Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 751–775 of 9,842

ticket, page 31 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
751	3000751958275	376
752	3000752236462	376
753	3000753233307	377
754	3000754470997	377
755	3000755879083	379
756	3000756682109	379
757	3000757284417	380
758	3000758118914	381
759	3000759186611	383
760	3000760831558	383
761	3000761896184	385
762	3000762814411	387
763	3000763497977	387
764	3000764731945	389
765	3000765276313	389
766	3000766290947	390
767	3000767367091	390
768	3000768332197	391
769	3000769664738	391
770	3000770321670	391
771	3000771802231	393
772	3000772381680	393
773	3000773576027	394
774	3000774347584	396
775	3000775119138	396

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;