Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 851–875 of 9,842

ticket, page 35 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
851	3000851999903	450
852	3000852273467	452
853	3000853017138	452
854	3000854877527	452
855	3000855116956	452
856	3000856444264	452
857	3000857901899	454
858	3000858875127	456
859	3000859926528	458
860	3000860329794	458
861	3000861349986	459
862	3000862519087	459
863	3000863167455	459
864	3000864615476	459
865	3000865310284	461
866	3000866515685	461
867	3000867845775	462
868	3000868553520	462
869	3000869652962	462
870	3000870788347	462
871	3000871553861	463
872	3000872268931	463
873	3000873516424	464
874	3000874684929	464
875	3000875137989	464

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;