Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 826–850 of 9,842

ticket, page 34 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
826	3000826494512	432
827	3000827611014	433
828	3000828157630	434
829	3000829695752	434
830	3000830761457	436
831	3000831063246	436
832	3000832987120	437
833	3000833258227	438
834	3000834720721	440
835	3000835337026	441
836	3000836501559	443
837	3000837626138	443
838	3000838563299	443
839	3000839138280	443
840	3000840302245	444
841	3000841656063	444
842	3000842873065	444
843	3000843426582	444
844	3000844822086	444
845	3000845868263	445
846	3000846562776	445
847	3000847857504	446
848	3000848577242	448
849	3000849500551	448
850	3000850994175	450

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;