Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,251–3,275 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3251 | 3003251720366 | 1795 |
| 3252 | 3003252923594 | 1795 |
| 3253 | 3003253368382 | 1797 |
| 3254 | 3003254004597 | 1797 |
| 3255 | 3003255945657 | 1797 |
| 3256 | 3003256757851 | 1797 |
| 3257 | 3003257922156 | 1797 |
| 3258 | 3003258661500 | 1797 |
| 3259 | 3003259424537 | 1797 |
| 3260 | 3003260633029 | 1797 |
| 3261 | 3003261335241 | 1797 |
| 3262 | 3003262551345 | 1797 |
| 3263 | 3003263289963 | 1797 |
| 3264 | 3003264663416 | 1797 |
| 3265 | 3003265814573 | 1797 |
| 3266 | 3003266960781 | 1797 |
| 3267 | 3003267412900 | 1797 |
| 3268 | 3003268139948 | 1797 |
| 3269 | 3003269988901 | 1797 |
| 3270 | 3003270068462 | 1797 |
| 3271 | 3003271368477 | 1797 |
| 3272 | 3003272044658 | 1797 |
| 3273 | 3003273216868 | 1797 |
| 3274 | 3003274339193 | 1797 |
| 3275 | 3003275223050 | 1797 |
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;