Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

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

ticket, page 140 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
3476	3003476867084	1879
3477	3003477164160	1879
3478	3003478176283	1880
3479	3003479376222	1880
3480	3003480075517	1881
3481	3003481712049	1881
3482	3003482014100	1882
3483	3003483421693	1887
3484	3003484360297	1888
3485	3003485676803	1891
3486	3003486719319	1893
3487	3003487124465	1893
3488	3003488850876	1895
3489	3003489161597	1895
3490	3003490877845	1895
3491	3003491647857	1895
3492	3003492715654	1899
3493	3003493826485	1901
3494	3003494295415	1903
3495	3003495673485	1905
3496	3003496153312	1905
3497	3003497485896	1906
3498	3003498268585	1906
3499	3003499874227	1909
3500	3003500613635	1910

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;