Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,626–5,650 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5626 | 3005626407153 | 3128 |
| 5627 | 3005627042195 | 3128 |
| 5628 | 3005628535260 | 3128 |
| 5629 | 3005629222756 | 3128 |
| 5630 | 3005630589230 | 3128 |
| 5631 | 3005631345785 | 3128 |
| 5632 | 3005632510052 | 3133 |
| 5633 | 3005633201600 | 3133 |
| 5634 | 3005634025657 | 3135 |
| 5635 | 3005635167468 | 3135 |
| 5636 | 3005636167699 | 3136 |
| 5637 | 3005637291057 | 3136 |
| 5638 | 3005638851706 | 3137 |
| 5639 | 3005639260097 | 3137 |
| 5640 | 3005640960900 | 3139 |
| 5641 | 3005641177986 | 3139 |
| 5642 | 3005642853627 | 3140 |
| 5643 | 3005643043463 | 3140 |
| 5644 | 3005644821581 | 3140 |
| 5645 | 3005645304190 | 3142 |
| 5646 | 3005646321641 | 3142 |
| 5647 | 3005647416966 | 3143 |
| 5648 | 3005648611822 | 3143 |
| 5649 | 3005649983890 | 3143 |
| 5650 | 3005650166219 | 3143 |
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;