Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 4,126–4,150 of 9,842

ticket, page 166 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
4126	3004126752521	2302
4127	3004127587880	2302
4128	3004128592165	2302
4129	3004129129666	2302
4130	3004130364172	2302
4131	3004131910689	2302
4132	3004132698071	2302
4133	3004133614612	2302
4134	3004134770618	2302
4135	3004135522127	2302
4136	3004136007222	2302
4137	3004137804253	2302
4138	3004138395850	2302
4139	3004139143014	2302
4140	3004140151811	2303
4141	3004141978998	2303
4142	3004142875779	2304
4143	3004143064542	2304
4144	3004144674307	2305
4145	3004145827871	2305
4146	3004146035705	2305
4147	3004147166594	2305
4148	3004148707011	2306
4149	3004149362667	2306
4150	3004150884467	2307

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;