Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 1,976–2,000 of 9,842

ticket, page 80 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
1976	3001976946503	1075
1977	3001977832065	1075
1978	3001978960513	1076
1979	3001979126353	1077
1980	3001980224302	1077
1981	3001981041978	1083
1982	3001982540620	1084
1983	3001983708128	1086
1984	3001984707689	1087
1985	3001985317008	1087
1986	3001986612542	1087
1987	3001987374269	1087
1988	3001988099483	1087
1989	3001989836346	1088
1990	3001990232821	1088
1991	3001991611683	1090
1992	3001992879754	1090
1993	3001993270147	1090
1994	3001994024957	1090
1995	3001995867799	1090
1996	3001996312756	1091
1997	3001997300596	1092
1998	3001998254525	1092
1999	3001999141652	1093
2000	3002000158166	1093

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;