Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,376–3,400 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3376 | 3003376347011 | 1836 |
| 3377 | 3003377542653 | 1836 |
| 3378 | 3003378113655 | 1836 |
| 3379 | 3003379978948 | 1836 |
| 3380 | 3003380204904 | 1836 |
| 3381 | 3003381498253 | 1836 |
| 3382 | 3003382052236 | 1837 |
| 3383 | 3003383289417 | 1837 |
| 3384 | 3003384888570 | 1837 |
| 3385 | 3003385707077 | 1841 |
| 3386 | 3003386153735 | 1841 |
| 3387 | 3003387501692 | 1841 |
| 3388 | 3003388655058 | 1842 |
| 3389 | 3003389515999 | 1843 |
| 3390 | 3003390412412 | 1843 |
| 3391 | 3003391969864 | 1848 |
| 3392 | 3003392173000 | 1848 |
| 3393 | 3003393983492 | 1849 |
| 3394 | 3003394039424 | 1851 |
| 3395 | 3003395374147 | 1852 |
| 3396 | 3003396335743 | 1852 |
| 3397 | 3003397160715 | 1852 |
| 3398 | 3003398833244 | 1854 |
| 3399 | 3003399599169 | 1854 |
| 3400 | 3003400656575 | 1854 |
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;