Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,601–1,625 of 9,842

ticket, page 65 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1601	3001601435626	887
1602	3001602787273	888
1603	3001603584493	888
1604	3001604417074	889
1605	3001605449372	889
1606	3001606129740	891
1607	3001607504709	891
1608	3001608614055	894
1609	3001609794273	894
1610	3001610621791	895
1611	3001611402513	896
1612	3001612272338	896
1613	3001613681350	896
1614	3001614629306	897
1615	3001615850722	897
1616	3001616841302	897
1617	3001617762133	897
1618	3001618414467	898
1619	3001619628169	899
1620	3001620437554	899
1621	3001621685851	900
1622	3001622133943	900
1623	3001623338979	901
1624	3001624448628	901
1625	3001625023339	903

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;