Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,751–4,775 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4751 | 3004751101482 | 2605 |
| 4752 | 3004752926706 | 2606 |
| 4753 | 3004753149342 | 2607 |
| 4754 | 3004754317819 | 2607 |
| 4755 | 3004755797861 | 2607 |
| 4756 | 3004756249938 | 2607 |
| 4757 | 3004757410202 | 2608 |
| 4758 | 3004758133820 | 2609 |
| 4759 | 3004759471494 | 2609 |
| 4760 | 3004760203674 | 2609 |
| 4761 | 3004761770851 | 2609 |
| 4762 | 3004762844466 | 2610 |
| 4763 | 3004763227479 | 2610 |
| 4764 | 3004764128353 | 2611 |
| 4765 | 3004765811225 | 2613 |
| 4766 | 3004766873148 | 2615 |
| 4767 | 3004767240778 | 2616 |
| 4768 | 3004768410641 | 2616 |
| 4769 | 3004769418397 | 2618 |
| 4770 | 3004770004188 | 2620 |
| 4771 | 3004771083368 | 2620 |
| 4772 | 3004772122144 | 2620 |
| 4773 | 3004773957256 | 2622 |
| 4774 | 3004774346210 | 2623 |
| 4775 | 3004775670844 | 2624 |
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;