Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 9,551–9,575 of 9,842

ticket, page 383 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
9551	3009551401834	5175
9552	3009552218019	5177
9553	3009553725522	5177
9554	3009554594948	5179
9555	3009555284474	5179
9556	3009556331985	5180
9557	3009557387507	5180
9558	3009558322559	5181
9559	3009559859863	5183
9560	3009560112184	5186
9561	3009561052076	5186
9562	3009562457798	5186
9563	3009563830727	5186
9564	3009564286640	5188
9565	3009565212857	5189
9566	3009566120665	5189
9567	3009567319705	5190
9568	3009568720952	5191
9569	3009569597139	5192
9570	3009570488369	5192
9571	3009571891322	5193
9572	3009572843536	5195
9573	3009573244497	5195
9574	3009574134842	5196
9575	3009575471676	5196

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;