Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 476–500 of 9,842

ticket, page 20 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
476	3000476911193	205
477	3000477637959	205
478	3000478929936	205
479	3000479875503	205
480	3000480017237	205
481	3000481200978	205
482	3000482540765	205
483	3000483844794	205
484	3000484898543	205
485	3000485996467	205
486	3000486202587	205
487	3000487221405	205
488	3000488977423	205
489	3000489806617	205
490	3000490788020	205
491	3000491462327	205
492	3000492220155	205
493	3000493245159	205
494	3000494319458	205
495	3000495461977	205
496	3000496998032	205
497	3000497781940	205
498	3000498700876	206
499	3000499291003	206
500	3000500551619	206

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;