Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 201–225 of 9,842

ticket, page 9 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
201	3000201678700	59
202	3000202291061	61
203	3000203228458	63
204	3000204828847	63
205	3000205799108	65
206	3000206295694	65
207	3000207142958	65
208	3000208588994	67
209	3000209561578	67
210	3000210295267	69
211	3000211199629	69
212	3000212749389	74
213	3000213583769	74
214	3000214168220	76
215	3000215232574	76
216	3000216233205	77
217	3000217082101	78
218	3000218875807	78
219	3000219308615	79
220	3000220754158	79
221	3000221167220	83
222	3000222559580	84
223	3000223811945	85
224	3000224414558	85
225	3000225540919	85

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;