Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 7,651–7,675 of 9,842

ticket, page 307 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
7651	3007651011162	4127
7652	3007652033436	4128
7653	3007653480769	4128
7654	3007654871677	4129
7655	3007655361065	4129
7656	3007656026567	4130
7657	3007657724614	4133
7658	3007658097536	4133
7659	3007659402064	4134
7660	3007660983483	4135
7661	3007661306582	4135
7662	3007662943422	4135
7663	3007663100142	4135
7664	3007664685540	4135
7665	3007665569636	4135
7666	3007666584775	4135
7667	3007667367347	4135
7668	3007668263008	4135
7669	3007669559422	4135
7670	3007670987658	4135
7671	3007671795169	4135
7672	3007672733069	4135
7673	3007673438561	4135
7674	3007674399114	4135
7675	3007675563123	4135

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;