Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,776–6,800 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6776 | 3006776824395 | 3718 |
| 6777 | 3006777636242 | 3720 |
| 6778 | 3006778794424 | 3720 |
| 6779 | 3006779219071 | 3721 |
| 6780 | 3006780034995 | 3721 |
| 6781 | 3006781908683 | 3722 |
| 6782 | 3006782710348 | 3722 |
| 6783 | 3006783154448 | 3724 |
| 6784 | 3006784812418 | 3726 |
| 6785 | 3006785973017 | 3726 |
| 6786 | 3006786755316 | 3726 |
| 6787 | 3006787642953 | 3726 |
| 6788 | 3006788867877 | 3728 |
| 6789 | 3006789286015 | 3728 |
| 6790 | 3006790623895 | 3730 |
| 6791 | 3006791945207 | 3730 |
| 6792 | 3006792180184 | 3730 |
| 6793 | 3006793136021 | 3730 |
| 6794 | 3006794380517 | 3730 |
| 6795 | 3006795727276 | 3730 |
| 6796 | 3006796975501 | 3730 |
| 6797 | 3006797497849 | 3730 |
| 6798 | 3006798493361 | 3730 |
| 6799 | 3006799522455 | 3730 |
| 6800 | 3006800740125 | 3730 |
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;