Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 4,476–4,500 of 9,842

ticket, page 180 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
4476	3004476397989	2486
4477	3004477703879	2486
4478	3004478354193	2487
4479	3004479464110	2487
4480	3004480162973	2487
4481	3004481561859	2487
4482	3004482725305	2489
4483	3004483774646	2490
4484	3004484912931	2490
4485	3004485158315	2491
4486	3004486532240	2491
4487	3004487470332	2492
4488	3004488608481	2492
4489	3004489137189	2492
4490	3004490902514	2493
4491	3004491668638	2494
4492	3004492678968	2494
4493	3004493598818	2494
4494	3004494128877	2494
4495	3004495365013	2495
4496	3004496389814	2495
4497	3004497480348	2495
4498	3004498477101	2495
4499	3004499634221	2499
4500	3004500720552	2499

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;