Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,601–8,625 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8601 | 3008601438416 | 4676 |
| 8602 | 3008602010325 | 4676 |
| 8603 | 3008603347744 | 4676 |
| 8604 | 3008604242788 | 4676 |
| 8605 | 3008605521874 | 4676 |
| 8606 | 3008606817667 | 4676 |
| 8607 | 3008607208195 | 4676 |
| 8608 | 3008608413804 | 4676 |
| 8609 | 3008609539672 | 4676 |
| 8610 | 3008610460704 | 4676 |
| 8611 | 3008611844616 | 4676 |
| 8612 | 3008612852292 | 4676 |
| 8613 | 3008613406379 | 4676 |
| 8614 | 3008614765547 | 4676 |
| 8615 | 3008615327589 | 4676 |
| 8616 | 3008616096988 | 4676 |
| 8617 | 3008617506841 | 4676 |
| 8618 | 3008618539192 | 4676 |
| 8619 | 3008619318076 | 4676 |
| 8620 | 3008620147871 | 4676 |
| 8621 | 3008621562086 | 4676 |
| 8622 | 3008622493474 | 4676 |
| 8623 | 3008623185049 | 4676 |
| 8624 | 3008624762535 | 4676 |
| 8625 | 3008625726656 | 4676 |
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;