Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 3,576–3,600 of 9,842

ticket, page 144 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
3576	3003576078255	1965
3577	3003577699177	1965
3578	3003578449862	1965
3579	3003579311337	1965
3580	3003580845153	1965
3581	3003581954558	1967
3582	3003582913100	1967
3583	3003583659616	1968
3584	3003584369642	1968
3585	3003585954370	1968
3586	3003586950149	1968
3587	3003587445315	1969
3588	3003588408388	1969
3589	3003589140271	1969
3590	3003590229640	1970
3591	3003591925871	1972
3592	3003592459532	1974
3593	3003593917971	1974
3594	3003594236083	1976
3595	3003595491108	1978
3596	3003596120023	1978
3597	3003597850439	1978
3598	3003598016716	1978
3599	3003599410269	1979
3600	3003600409240	1979

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;