Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,351–3,375 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3351 | 3003351715009 | 1836 |
| 3352 | 3003352182031 | 1836 |
| 3353 | 3003353154157 | 1836 |
| 3354 | 3003354735348 | 1836 |
| 3355 | 3003355316396 | 1836 |
| 3356 | 3003356407775 | 1836 |
| 3357 | 3003357049568 | 1836 |
| 3358 | 3003358091811 | 1836 |
| 3359 | 3003359905723 | 1836 |
| 3360 | 3003360295473 | 1836 |
| 3361 | 3003361507472 | 1836 |
| 3362 | 3003362649951 | 1836 |
| 3363 | 3003363112957 | 1836 |
| 3364 | 3003364603687 | 1836 |
| 3365 | 3003365657173 | 1836 |
| 3366 | 3003366804214 | 1836 |
| 3367 | 3003367799471 | 1836 |
| 3368 | 3003368232420 | 1836 |
| 3369 | 3003369095431 | 1836 |
| 3370 | 3003370103516 | 1836 |
| 3371 | 3003371782311 | 1836 |
| 3372 | 3003372622079 | 1836 |
| 3373 | 3003373352213 | 1836 |
| 3374 | 3003374559774 | 1836 |
| 3375 | 3003375622278 | 1836 |
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;