Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,376–2,400 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2376 | 3002376766855 | 1311 |
| 2377 | 3002377614032 | 1313 |
| 2378 | 3002378597953 | 1313 |
| 2379 | 3002379128185 | 1314 |
| 2380 | 3002380411923 | 1314 |
| 2381 | 3002381991288 | 1314 |
| 2382 | 3002382417362 | 1316 |
| 2383 | 3002383726104 | 1316 |
| 2384 | 3002384743592 | 1316 |
| 2385 | 3002385915229 | 1316 |
| 2386 | 3002386070502 | 1318 |
| 2387 | 3002387236505 | 1319 |
| 2388 | 3002388749278 | 1319 |
| 2389 | 3002389640758 | 1319 |
| 2390 | 3002390661806 | 1320 |
| 2391 | 3002391934731 | 1321 |
| 2392 | 3002392288440 | 1321 |
| 2393 | 3002393150788 | 1322 |
| 2394 | 3002394892000 | 1322 |
| 2395 | 3002395960919 | 1322 |
| 2396 | 3002396612074 | 1324 |
| 2397 | 3002397047932 | 1325 |
| 2398 | 3002398817196 | 1327 |
| 2399 | 3002399095773 | 1327 |
| 2400 | 3002400457364 | 1327 |
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;