Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 3,926–3,950 of 9,842

ticket, page 158 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
3926	3003926558438	2155
3927	3003927068514	2155
3928	3003928613221	2155
3929	3003929114645	2156
3930	3003930007050	2156
3931	3003931294511	2158
3932	3003932682287	2158
3933	3003933586096	2158
3934	3003934585585	2158
3935	3003935857763	2159
3936	3003936768424	2161
3937	3003937096286	2162
3938	3003938733931	2162
3939	3003939440158	2162
3940	3003940967789	2164
3941	3003941989207	2166
3942	3003942750876	2167
3943	3003943806297	2169
3944	3003944321731	2169
3945	3003945382143	2169
3946	3003946706694	2169
3947	3003947873587	2169
3948	3003948778877	2170
3949	3003949332091	2170
3950	3003950229148	2171

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;