Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 451–475 of 9,842

ticket, page 19 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
451	3000451932319	203
452	3000452194219	205
453	3000453133018	205
454	3000454978866	205
455	3000455739441	205
456	3000456486065	205
457	3000457978685	205
458	3000458039923	205
459	3000459262783	205
460	3000460816659	205
461	3000461914316	205
462	3000462511740	205
463	3000463416486	205
464	3000464541448	205
465	3000465602349	205
466	3000466852245	205
467	3000467294154	205
468	3000468451972	205
469	3000469460580	205
470	3000470725351	205
471	3000471110763	205
472	3000472016572	205
473	3000473179439	205
474	3000474822110	205
475	3000475894256	205

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;