Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,826–1,850 of 9,842

ticket, page 74 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1826	3001826142335	1015
1827	3001827432293	1019
1828	3001828089473	1019
1829	3001829721480	1019
1830	3001830780244	1019
1831	3001831952639	1021
1832	3001832332672	1025
1833	3001833783250	1025
1834	3001834422458	1025
1835	3001835285554	1025
1836	3001836891171	1025
1837	3001837739374	1026
1838	3001838779225	1026
1839	3001839517731	1026
1840	3001840222689	1027
1841	3001841397973	1027
1842	3001842507003	1027
1843	3001843019892	1027
1844	3001844677029	1028
1845	3001845337278	1028
1846	3001846221028	1029
1847	3001847619553	1029
1848	3001848428811	1029
1849	3001849001791	1029
1850	3001850409613	1030

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;