Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,551–5,575 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5551 | 3005551506992 | 3097 |
| 5552 | 3005552229751 | 3098 |
| 5553 | 3005553266431 | 3098 |
| 5554 | 3005554845790 | 3098 |
| 5555 | 3005555450570 | 3101 |
| 5556 | 3005556482037 | 3101 |
| 5557 | 3005557513375 | 3103 |
| 5558 | 3005558991254 | 3104 |
| 5559 | 3005559224455 | 3104 |
| 5560 | 3005560318999 | 3104 |
| 5561 | 3005561344445 | 3105 |
| 5562 | 3005562953102 | 3107 |
| 5563 | 3005563518682 | 3107 |
| 5564 | 3005564235515 | 3108 |
| 5565 | 3005565746180 | 3108 |
| 5566 | 3005566350146 | 3108 |
| 5567 | 3005567046981 | 3108 |
| 5568 | 3005568757596 | 3108 |
| 5569 | 3005569980925 | 3111 |
| 5570 | 3005570823572 | 3112 |
| 5571 | 3005571145448 | 3112 |
| 5572 | 3005572865748 | 3113 |
| 5573 | 3005573490704 | 3114 |
| 5574 | 3005574149671 | 3115 |
| 5575 | 3005575271362 | 3115 |
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;