Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,276–2,300 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2276 | 3002276126450 | 1237 |
| 2277 | 3002277766738 | 1237 |
| 2278 | 3002278819440 | 1238 |
| 2279 | 3002279023322 | 1238 |
| 2280 | 3002280635169 | 1240 |
| 2281 | 3002281662902 | 1240 |
| 2282 | 3002282218767 | 1244 |
| 2283 | 3002283567085 | 1245 |
| 2284 | 3002284048035 | 1245 |
| 2285 | 3002285242764 | 1249 |
| 2286 | 3002286508799 | 1249 |
| 2287 | 3002287600402 | 1250 |
| 2288 | 3002288123508 | 1252 |
| 2289 | 3002289135296 | 1252 |
| 2290 | 3002290225054 | 1254 |
| 2291 | 3002291108186 | 1254 |
| 2292 | 3002292537474 | 1255 |
| 2293 | 3002293634415 | 1257 |
| 2294 | 3002294016608 | 1257 |
| 2295 | 3002295275862 | 1258 |
| 2296 | 3002296723156 | 1259 |
| 2297 | 3002297144582 | 1259 |
| 2298 | 3002298781194 | 1261 |
| 2299 | 3002299446746 | 1261 |
| 2300 | 3002300631147 | 1263 |
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;