Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 351–375 of 9,842

ticket, page 15 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
351	3000351855132	176
352	3000352774249	176
353	3000353323923	176
354	3000354649176	177
355	3000355530818	177
356	3000356744387	178
357	3000357900267	178
358	3000358676113	179
359	3000359745127	179
360	3000360905312	179
361	3000361391288	180
362	3000362141292	180
363	3000363495095	180
364	3000364609911	180
365	3000365631908	180
366	3000366202215	180
367	3000367243189	180
368	3000368148021	180
369	3000369404467	180
370	3000370578392	180
371	3000371326863	180
372	3000372422714	180
373	3000373972781	180
374	3000374453274	180
375	3000375745245	180

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;