Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 2,176–2,200 of 9,842

ticket, page 88 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
2176	3002176978001	1202
2177	3002177048476	1202
2178	3002178065438	1202
2179	3002179632419	1202
2180	3002180001413	1202
2181	3002181426751	1202
2182	3002182107149	1202
2183	3002183046334	1202
2184	3002184860411	1202
2185	3002185714555	1202
2186	3002186362212	1202
2187	3002187699289	1202
2188	3002188598470	1202
2189	3002189018458	1202
2190	3002190136437	1202
2191	3002191777969	1202
2192	3002192862999	1202
2193	3002193662478	1202
2194	3002194563557	1202
2195	3002195256667	1202
2196	3002196665035	1202
2197	3002197985431	1202
2198	3002198800306	1204
2199	3002199788101	1204
2200	3002200720674	1206

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;