Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,751–1,775 of 9,842

ticket, page 71 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1751	3001751897633	961
1752	3001752215336	963
1753	3001753088671	963
1754	3001754106487	963
1755	3001755103073	964
1756	3001756954580	964
1757	3001757361940	966
1758	3001758710999	966
1759	3001759840766	968
1760	3001760851681	968
1761	3001761949946	968
1762	3001762244769	971
1763	3001763933426	972
1764	3001764326618	972
1765	3001765557168	973
1766	3001766272401	973
1767	3001767966231	975
1768	3001768234148	975
1769	3001769341804	975
1770	3001770740232	976
1771	3001771025100	977
1772	3001772759440	977
1773	3001773822853	978
1774	3001774263892	978
1775	3001775371687	979

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;