Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 4,301–4,325 of 9,842

ticket, page 173 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
4301	3004301336220	2386
4302	3004302700341	2386
4303	3004303336350	2387
4304	3004304457985	2387
4305	3004305933062	2388
4306	3004306408151	2389
4307	3004307472042	2389
4308	3004308918889	2390
4309	3004309906970	2391
4310	3004310195344	2392
4311	3004311461143	2393
4312	3004312538096	2393
4313	3004313775987	2396
4314	3004314944512	2398
4315	3004315831083	2398
4316	3004316344850	2400
4317	3004317993993	2401
4318	3004318573454	2401
4319	3004319494834	2402
4320	3004320906906	2402
4321	3004321484971	2403
4322	3004322149639	2403
4323	3004323177841	2404
4324	3004324608692	2407
4325	3004325153360	2408

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;