Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 776–800 of 9,842

ticket, page 32 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
776	3000776420473	398
777	3000777298060	398
778	3000778425232	399
779	3000779011390	401
780	3000780591294	401
781	3000781124778	401
782	3000782058315	402
783	3000783466988	402
784	3000784670209	402
785	3000785031706	402
786	3000786847197	402
787	3000787453889	406
788	3000788710873	407
789	3000789754449	408
790	3000790019498	409
791	3000791464569	410
792	3000792240689	410
793	3000793658701	410
794	3000794990337	411
795	3000795858800	413
796	3000796881114	413
797	3000797330213	413
798	3000798383045	413
799	3000799751638	413
800	3000800572785	415

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;