Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,651–4,675 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4651 | 3004651697627 | 2572 |
| 4652 | 3004652701469 | 2572 |
| 4653 | 3004653958666 | 2572 |
| 4654 | 3004654630831 | 2574 |
| 4655 | 3004655221285 | 2574 |
| 4656 | 3004656162271 | 2575 |
| 4657 | 3004657714841 | 2575 |
| 4658 | 3004658890424 | 2576 |
| 4659 | 3004659028817 | 2576 |
| 4660 | 3004660076715 | 2577 |
| 4661 | 3004661024428 | 2577 |
| 4662 | 3004662828117 | 2580 |
| 4663 | 3004663042910 | 2582 |
| 4664 | 3004664293865 | 2582 |
| 4665 | 3004665559989 | 2582 |
| 4666 | 3004666874500 | 2582 |
| 4667 | 3004667114114 | 2584 |
| 4668 | 3004668252563 | 2585 |
| 4669 | 3004669515379 | 2585 |
| 4670 | 3004670299927 | 2587 |
| 4671 | 3004671282641 | 2588 |
| 4672 | 3004672858618 | 2588 |
| 4673 | 3004673173004 | 2589 |
| 4674 | 3004674988558 | 2590 |
| 4675 | 3004675696374 | 2590 |
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;