Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,826–3,850 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3826 | 3003826529777 | 2088 |
| 3827 | 3003827638270 | 2088 |
| 3828 | 3003828903193 | 2088 |
| 3829 | 3003829757967 | 2090 |
| 3830 | 3003830249383 | 2090 |
| 3831 | 3003831670102 | 2091 |
| 3832 | 3003832568105 | 2091 |
| 3833 | 3003833847494 | 2092 |
| 3834 | 3003834240081 | 2092 |
| 3835 | 3003835852225 | 2094 |
| 3836 | 3003836667971 | 2094 |
| 3837 | 3003837505210 | 2094 |
| 3838 | 3003838222701 | 2094 |
| 3839 | 3003839829160 | 2094 |
| 3840 | 3003840750399 | 2095 |
| 3841 | 3003841923455 | 2095 |
| 3842 | 3003842319730 | 2099 |
| 3843 | 3003843346425 | 2101 |
| 3844 | 3003844840740 | 2101 |
| 3845 | 3003845183307 | 2101 |
| 3846 | 3003846261178 | 2101 |
| 3847 | 3003847017031 | 2101 |
| 3848 | 3003848382537 | 2105 |
| 3849 | 3003849267213 | 2106 |
| 3850 | 3003850288232 | 2107 |
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;