Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 501–525 of 9,842

ticket, page 21 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
501	3000501916596	206
502	3000502093784	207
503	3000503405733	207
504	3000504195643	208
505	3000505399764	210
506	3000506660442	214
507	3000507402051	215
508	3000508304807	217
509	3000509385246	217
510	3000510116569	218
511	3000511061960	219
512	3000512118802	219
513	3000513020270	219
514	3000514854623	221
515	3000515380625	221
516	3000516760225	221
517	3000517572082	221
518	3000518110649	222
519	3000519043860	223
520	3000520879082	223
521	3000521051300	223
522	3000522072722	223
523	3000523771045	224
524	3000524977237	225
525	3000525277911	225

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;