Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 226–250 of 9,842

ticket, page 10 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
226	3000226918320	85
227	3000227014129	87
228	3000228502276	87
229	3000229838567	88
230	3000230550427	89
231	3000231757036	90
232	3000232369405	90
233	3000233673930	91
234	3000234027474	91
235	3000235102591	93
236	3000236267940	93
237	3000237850357	96
238	3000238252043	96
239	3000239157876	96
240	3000240925715	98
241	3000241811153	99
242	3000242160299	99
243	3000243926815	100
244	3000244714197	100
245	3000245903996	100
246	3000246940898	100
247	3000247760138	103
248	3000248698111	103
249	3000249401990	103
250	3000250118977	103

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;