Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,626–1,650 of 9,842

ticket, page 66 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1626	3001626077192	906
1627	3001627639832	906
1628	3001628001323	906
1629	3001629145070	906
1630	3001630461564	906
1631	3001631019523	907
1632	3001632532431	907
1633	3001633057273	908
1634	3001634014524	911
1635	3001635787946	913
1636	3001636920280	914
1637	3001637571193	915
1638	3001638287586	915
1639	3001639485247	915
1640	3001640506855	915
1641	3001641298917	916
1642	3001642196498	916
1643	3001643234104	917
1644	3001644337694	919
1645	3001645025372	919
1646	3001646522469	919
1647	3001647216475	919
1648	3001648756539	919
1649	3001649039482	920
1650	3001650521960	920

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;