Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,626–4,650 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4626 | 3004626387675 | 2557 |
| 4627 | 3004627262687 | 2557 |
| 4628 | 3004628832334 | 2557 |
| 4629 | 3004629722116 | 2557 |
| 4630 | 3004630702743 | 2557 |
| 4631 | 3004631705734 | 2557 |
| 4632 | 3004632890737 | 2557 |
| 4633 | 3004633840215 | 2557 |
| 4634 | 3004634276736 | 2557 |
| 4635 | 3004635448109 | 2557 |
| 4636 | 3004636518143 | 2559 |
| 4637 | 3004637535019 | 2565 |
| 4638 | 3004638414066 | 2565 |
| 4639 | 3004639076000 | 2567 |
| 4640 | 3004640317474 | 2567 |
| 4641 | 3004641758071 | 2567 |
| 4642 | 3004642933045 | 2567 |
| 4643 | 3004643895488 | 2567 |
| 4644 | 3004644110023 | 2568 |
| 4645 | 3004645089117 | 2568 |
| 4646 | 3004646758540 | 2568 |
| 4647 | 3004647620050 | 2569 |
| 4648 | 3004648832700 | 2570 |
| 4649 | 3004649585137 | 2571 |
| 4650 | 3004650296700 | 2571 |
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;