Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 176–200 of 9,842

ticket, page 8 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
176	3000176002270	59
177	3000177595142	59
178	3000178279869	59
179	3000179495114	59
180	3000180031017	59
181	3000181076233	59
182	3000182428930	59
183	3000183299456	59
184	3000184165856	59
185	3000185906189	59
186	3000186321292	59
187	3000187554791	59
188	3000188849467	59
189	3000189918530	59
190	3000190774353	59
191	3000191297660	59
192	3000192741043	59
193	3000193004083	59
194	3000194387772	59
195	3000195143355	59
196	3000196846993	59
197	3000197967457	59
198	3000198954757	59
199	3000199939797	59
200	3000200526926	59

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;