Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 326–350 of 9,842

ticket, page 14 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
326	3000326317571	158
327	3000327767807	159
328	3000328272904	161
329	3000329454790	161
330	3000330704953	161
331	3000331112181	165
332	3000332185926	167
333	3000333724728	167
334	3000334377731	167
335	3000335973585	167
336	3000336723268	168
337	3000337795617	168
338	3000338132983	168
339	3000339956722	171
340	3000340365390	171
341	3000341780834	172
342	3000342757541	172
343	3000343102946	173
344	3000344917749	173
345	3000345541326	173
346	3000346150251	173
347	3000347901252	173
348	3000348273939	174
349	3000349847533	176
350	3000350156386	176

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;