Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,701–1,725 of 9,842

ticket, page 69 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1701	3001701622688	945
1702	3001702259831	945
1703	3001703001740	945
1704	3001704347740	945
1705	3001705949805	945
1706	3001706833035	945
1707	3001707065731	945
1708	3001708016876	945
1709	3001709131213	945
1710	3001710063725	945
1711	3001711879786	945
1712	3001712293513	945
1713	3001713568572	945
1714	3001714462365	945
1715	3001715058147	945
1716	3001716666394	945
1717	3001717078657	945
1718	3001718953509	945
1719	3001719868395	945
1720	3001720239582	945
1721	3001721789471	945
1722	3001722741505	945
1723	3001723210354	945
1724	3001724750462	945
1725	3001725356310	945

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;