Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,451–2,475 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2451 | 3002451345548 | 1368 |
| 2452 | 3002452330366 | 1369 |
| 2453 | 3002453780697 | 1371 |
| 2454 | 3002454226176 | 1374 |
| 2455 | 3002455033667 | 1374 |
| 2456 | 3002456780602 | 1374 |
| 2457 | 3002457635287 | 1376 |
| 2458 | 3002458201099 | 1377 |
| 2459 | 3002459253611 | 1377 |
| 2460 | 3002460494783 | 1378 |
| 2461 | 3002461467756 | 1378 |
| 2462 | 3002462121956 | 1378 |
| 2463 | 3002463418775 | 1380 |
| 2464 | 3002464574656 | 1380 |
| 2465 | 3002465708162 | 1381 |
| 2466 | 3002466827662 | 1381 |
| 2467 | 3002467914867 | 1381 |
| 2468 | 3002468029115 | 1381 |
| 2469 | 3002469734744 | 1382 |
| 2470 | 3002470268172 | 1382 |
| 2471 | 3002471544196 | 1384 |
| 2472 | 3002472121313 | 1384 |
| 2473 | 3002473789940 | 1385 |
| 2474 | 3002474968586 | 1387 |
| 2475 | 3002475399876 | 1387 |
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;