Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 426–450 of 9,842

ticket, page 18 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
426	3000426479275	190
427	3000427301547	190
428	3000428090412	193
429	3000429301243	193
430	3000430093212	193
431	3000431169790	193
432	3000432683985	196
433	3000433700252	196
434	3000434269834	196
435	3000435372422	197
436	3000436274507	197
437	3000437950806	197
438	3000438511427	197
439	3000439697756	197
440	3000440385954	199
441	3000441837838	199
442	3000442374973	200
443	3000443228694	201
444	3000444411327	202
445	3000445541890	202
446	3000446085226	202
447	3000447985183	203
448	3000448030418	203
449	3000449528789	203
450	3000450825874	203

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;