Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 6,901–6,925 of 9,842

ticket, page 277 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
6901	3006901009893	3797
6902	3006902554145	3798
6903	3006903108312	3798
6904	3006904970607	3798
6905	3006905132436	3798
6906	3006906542732	3804
6907	3006907841449	3804
6908	3006908615946	3804
6909	3006909639084	3807
6910	3006910935325	3807
6911	3006911862038	3808
6912	3006912189099	3809
6913	3006913193452	3809
6914	3006914674562	3809
6915	3006915746991	3809
6916	3006916993527	3810
6917	3006917280650	3811
6918	3006918010220	3811
6919	3006919927044	3811
6920	3006920367071	3811
6921	3006921577633	3813
6922	3006922822084	3813
6923	3006923947274	3814
6924	3006924720554	3814
6925	3006925673930	3815

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;