Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,701–9,725 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9701 | 3009701247511 | 5298 |
| 9702 | 3009702720677 | 5298 |
| 9703 | 3009703468084 | 5299 |
| 9704 | 3009704261640 | 5300 |
| 9705 | 3009705000818 | 5300 |
| 9706 | 3009706784279 | 5300 |
| 9707 | 3009707550403 | 5301 |
| 9708 | 3009708353561 | 5301 |
| 9709 | 3009709044963 | 5302 |
| 9710 | 3009710585577 | 5302 |
| 9711 | 3009711886164 | 5303 |
| 9712 | 3009712572585 | 5304 |
| 9713 | 3009713482730 | 5304 |
| 9714 | 3009714990918 | 5307 |
| 9715 | 3009715361094 | 5307 |
| 9716 | 3009716033429 | 5309 |
| 9717 | 3009717384653 | 5310 |
| 9718 | 3009718492017 | 5310 |
| 9719 | 3009719821610 | 5310 |
| 9720 | 3009720818430 | 5310 |
| 9721 | 3009721178040 | 5313 |
| 9722 | 3009722939471 | 5313 |
| 9723 | 3009723555841 | 5315 |
| 9724 | 3009724946632 | 5315 |
| 9725 | 3009725998766 | 5315 |
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;