Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 7,676–7,700 of 9,842

ticket, page 308 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
7676	3007676795394	4135
7677	3007677316749	4135
7678	3007678901347	4135
7679	3007679742753	4135
7680	3007680343500	4135
7681	3007681714970	4135
7682	3007682753345	4135
7683	3007683846422	4135
7684	3007684517950	4135
7685	3007685618112	4135
7686	3007686947395	4135
7687	3007687036325	4135
7688	3007688660108	4135
7689	3007689155351	4135
7690	3007690431650	4135
7691	3007691332578	4135
7692	3007692275734	4135
7693	3007693076511	4135
7694	3007694369086	4135
7695	3007695926543	4135
7696	3007696707194	4135
7697	3007697587721	4135
7698	3007698764930	4135
7699	3007699313028	4135
7700	3007700012934	4135

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;