Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,026–1,050 of 9,842

ticket, page 42 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1026	3001026975784	568
1027	3001027264434	569
1028	3001028143816	569
1029	3001029845189	570
1030	3001030123437	572
1031	3001031558942	572
1032	3001032599888	573
1033	3001033360583	573
1034	3001034552326	574
1035	3001035825754	574
1036	3001036107317	575
1037	3001037246184	575
1038	3001038971353	575
1039	3001039744797	575
1040	3001040066649	576
1041	3001041935360	576
1042	3001042692669	582
1043	3001043213345	582
1044	3001044411121	584
1045	3001045121266	585
1046	3001046125372	585
1047	3001047772153	586
1048	3001048325872	587
1049	3001049945341	590
1050	3001050183741	591

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;