Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,801–4,825 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4801 | 3004801912225 | 2636 |
| 4802 | 3004802467264 | 2636 |
| 4803 | 3004803535849 | 2636 |
| 4804 | 3004804827856 | 2638 |
| 4805 | 3004805050984 | 2638 |
| 4806 | 3004806877043 | 2638 |
| 4807 | 3004807033139 | 2641 |
| 4808 | 3004808919970 | 2641 |
| 4809 | 3004809420882 | 2646 |
| 4810 | 3004810910058 | 2650 |
| 4811 | 3004811089431 | 2651 |
| 4812 | 3004812296203 | 2651 |
| 4813 | 3004813450529 | 2651 |
| 4814 | 3004814552206 | 2652 |
| 4815 | 3004815793504 | 2653 |
| 4816 | 3004816404268 | 2653 |
| 4817 | 3004817843743 | 2654 |
| 4818 | 3004818430207 | 2654 |
| 4819 | 3004819528208 | 2657 |
| 4820 | 3004820756962 | 2657 |
| 4821 | 3004821799761 | 2657 |
| 4822 | 3004822388248 | 2658 |
| 4823 | 3004823176387 | 2658 |
| 4824 | 3004824034061 | 2659 |
| 4825 | 3004825382995 | 2659 |
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;