Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,726–4,750 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4726 | 3004726783514 | 2596 |
| 4727 | 3004727570072 | 2596 |
| 4728 | 3004728049551 | 2596 |
| 4729 | 3004729591759 | 2596 |
| 4730 | 3004730772523 | 2596 |
| 4731 | 3004731179256 | 2596 |
| 4732 | 3004732068766 | 2596 |
| 4733 | 3004733193166 | 2596 |
| 4734 | 3004734386302 | 2596 |
| 4735 | 3004735894014 | 2596 |
| 4736 | 3004736487037 | 2596 |
| 4737 | 3004737691230 | 2596 |
| 4738 | 3004738374191 | 2596 |
| 4739 | 3004739389350 | 2596 |
| 4740 | 3004740106651 | 2596 |
| 4741 | 3004741656627 | 2596 |
| 4742 | 3004742847014 | 2598 |
| 4743 | 3004743012427 | 2600 |
| 4744 | 3004744788193 | 2600 |
| 4745 | 3004745911083 | 2601 |
| 4746 | 3004746883674 | 2602 |
| 4747 | 3004747523802 | 2602 |
| 4748 | 3004748617455 | 2603 |
| 4749 | 3004749615198 | 2604 |
| 4750 | 3004750109770 | 2605 |
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;