Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 276–300 of 9,842

ticket, page 12 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
276	3000276258130	126
277	3000277344951	126
278	3000278077467	128
279	3000279877553	129
280	3000280655423	129
281	3000281015714	130
282	3000282712134	131
283	3000283413177	134
284	3000284816342	135
285	3000285639771	138
286	3000286133801	138
287	3000287866594	138
288	3000288846832	138
289	3000289938551	139
290	3000290234517	139
291	3000291528442	140
292	3000292146952	141
293	3000293751031	141
294	3000294264462	142
295	3000295421477	142
296	3000296128398	143
297	3000297235340	143
298	3000298959562	144
299	3000299364729	144
300	3000300476259	145

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;