Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 301–325 of 9,842

ticket, page 13 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
301	3000301448735	145
302	3000302873044	146
303	3000303411387	146
304	3000304641224	146
305	3000305905939	147
306	3000306564691	148
307	3000307652147	148
308	3000308996836	149
309	3000309768496	149
310	3000310157289	151
311	3000311797506	151
312	3000312804554	151
313	3000313194341	151
314	3000314558502	151
315	3000315571154	153
316	3000316529346	153
317	3000317096673	154
318	3000318843139	155
319	3000319947402	156
320	3000320284248	157
321	3000321189860	157
322	3000322218249	158
323	3000323963585	158
324	3000324690037	158
325	3000325284937	158

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;