Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 8,376–8,400 of 9,842

ticket, page 336 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
8376	3008376414805	4526
8377	3008377949533	4527
8378	3008378366454	4527
8379	3008379959276	4528
8380	3008380776535	4528
8381	3008381383935	4528
8382	3008382742578	4528
8383	3008383691905	4528
8384	3008384380285	4529
8385	3008385857988	4531
8386	3008386463227	4531
8387	3008387322327	4532
8388	3008388052632	4534
8389	3008389010403	4534
8390	3008390895362	4534
8391	3008391658868	4535
8392	3008392403498	4535
8393	3008393448103	4535
8394	3008394999943	4535
8395	3008395084043	4535
8396	3008396216132	4536
8397	3008397506403	4537
8398	3008398648784	4538
8399	3008399764634	4540
8400	3008400506331	4541

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;