Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 3,501–3,525 of 9,842

ticket, page 141 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
3501	3003501572871	1910
3502	3003502698337	1910
3503	3003503953708	1911
3504	3003504931223	1911
3505	3003505043636	1912
3506	3003506518501	1912
3507	3003507653623	1912
3508	3003508943515	1914
3509	3003509936306	1914
3510	3003510348968	1914
3511	3003511332825	1915
3512	3003512885503	1915
3513	3003513602687	1916
3514	3003514211589	1918
3515	3003515418735	1918
3516	3003516782244	1918
3517	3003517918163	1918
3518	3003518930591	1920
3519	3003519544878	1920
3520	3003520147800	1920
3521	3003521962253	1921
3522	3003522707424	1921
3523	3003523783759	1922
3524	3003524526245	1922
3525	3003525263104	1924

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;