Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 126–150 of 9,842

ticket, page 6 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
126	3000126400006	51
127	3000127678676	51
128	3000128677840	51
129	3000129030930	51
130	3000130711058	51
131	3000131608718	51
132	3000132006580	51
133	3000133046918	51
134	3000134713947	51
135	3000135153933	51
136	3000136649183	51
137	3000137383579	51
138	3000138265911	51
139	3000139683022	51
140	3000140714889	51
141	3000141611564	51
142	3000142005175	51
143	3000143717152	51
144	3000144488209	51
145	3000145268338	51
146	3000146532012	51
147	3000147130385	51
148	3000148666132	51
149	3000149470645	51
150	3000150558398	51

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;