Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 701–725 of 9,842

ticket, page 29 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
701	3000701572409	333
702	3000702140627	334
703	3000703724602	334
704	3000704547458	334
705	3000705068680	335
706	3000706856169	337
707	3000707392733	337
708	3000708042604	337
709	3000709170897	338
710	3000710882020	338
711	3000711550772	338
712	3000712440459	339
713	3000713455808	339
714	3000714759345	341
715	3000715543837	345
716	3000716712747	345
717	3000717089040	348
718	3000718328814	352
719	3000719864893	353
720	3000720232113	353
721	3000721180043	355
722	3000722459479	357
723	3000723880603	357
724	3000724553988	357
725	3000725242629	358

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;