Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 7,751–7,775 of 9,842

ticket, page 311 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
7751	3007751912369	4167
7752	3007752018704	4167
7753	3007753661038	4167
7754	3007754057664	4168
7755	3007755933726	4168
7756	3007756695452	4168
7757	3007757864847	4169
7758	3007758148637	4169
7759	3007759703840	4169
7760	3007760309210	4169
7761	3007761045345	4169
7762	3007762433990	4170
7763	3007763754100	4170
7764	3007764011341	4170
7765	3007765984195	4170
7766	3007766457921	4171
7767	3007767604297	4171
7768	3007768294582	4172
7769	3007769992302	4172
7770	3007770983284	4172
7771	3007771658185	4173
7772	3007772965408	4173
7773	3007773050398	4175
7774	3007774964826	4176
7775	3007775283534	4178

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;