Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 876–900 of 9,842

ticket, page 36 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
876	3000876060966	464
877	3000877219857	465
878	3000878436682	465
879	3000879834042	465
880	3000880057692	466
881	3000881552130	466
882	3000882165047	466
883	3000883690752	466
884	3000884125417	469
885	3000885832118	469
886	3000886370565	469
887	3000887642069	470
888	3000888652599	470
889	3000889610282	474
890	3000890336112	474
891	3000891947681	475
892	3000892498836	475
893	3000893631602	476
894	3000894781789	476
895	3000895657752	478
896	3000896848715	478
897	3000897491355	479
898	3000898230914	480
899	3000899625387	480
900	3000900604986	481

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;