Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 251–275 of 9,842

ticket, page 11 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
251	3000251276889	103
252	3000252333092	104
253	3000253172086	104
254	3000254599941	105
255	3000255513673	106
256	3000256350429	108
257	3000257709861	108
258	3000258321155	109
259	3000259231969	109
260	3000260384371	112
261	3000261656646	112
262	3000262325703	115
263	3000263364771	115
264	3000264137472	115
265	3000265244120	115
266	3000266643441	118
267	3000267274196	119
268	3000268343974	120
269	3000269991680	120
270	3000270561230	123
271	3000271114309	124
272	3000272753361	124
273	3000273946329	124
274	3000274323582	124
275	3000275032894	126

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;