Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 76–100 of 9,842

ticket, page 4 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
76	3000076727336	14
77	3000077132751	14
78	3000078699253	15
79	3000079299709	15
80	3000080654973	16
81	3000081168051	17
82	3000082152201	18
83	3000083712479	20
84	3000084002259	20
85	3000085390460	20
86	3000086995382	21
87	3000087785049	22
88	3000088022672	23
89	3000089751494	23
90	3000090401881	25
91	3000091648903	27
92	3000092509061	27
93	3000093520298	31
94	3000094319014	31
95	3000095311686	31
96	3000096830546	31
97	3000097161534	32
98	3000098625364	33
99	3000099203890	33
100	3000100721037	34

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;