Table

ticket

Each admission ticket and its unique barcode.

Replaces in 2020: Ticket

Rows 2,251–2,275 of 9,842

ticket, page 91 of 394
ticket_idINTEGER	barcodeTEXT	order_id→ purchase_order.order_id
2251	3002251170981	1218
2252	3002252435917	1218
2253	3002253887336	1219
2254	3002254012375	1220
2255	3002255966166	1221
2256	3002256938215	1222
2257	3002257985298	1223
2258	3002258648320	1226
2259	3002259583216	1228
2260	3002260434961	1228
2261	3002261081853	1228
2262	3002262356759	1229
2263	3002263172340	1229
2264	3002264477555	1229
2265	3002265858719	1230
2266	3002266959703	1230
2267	3002267942133	1231
2268	3002268581993	1231
2269	3002269319869	1233
2270	3002270505625	1233
2271	3002271951297	1234
2272	3002272006302	1234
2273	3002273364145	1234
2274	3002274782618	1237
2275	3002275314925	1237

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;