Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,801–7,825 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7801 | 3007801719174 | 4193 |
| 7802 | 3007802675839 | 4193 |
| 7803 | 3007803475399 | 4196 |
| 7804 | 3007804744714 | 4198 |
| 7805 | 3007805493064 | 4199 |
| 7806 | 3007806007021 | 4199 |
| 7807 | 3007807914958 | 4201 |
| 7808 | 3007808406094 | 4201 |
| 7809 | 3007809452568 | 4203 |
| 7810 | 3007810770080 | 4203 |
| 7811 | 3007811805408 | 4207 |
| 7812 | 3007812574975 | 4209 |
| 7813 | 3007813338818 | 4209 |
| 7814 | 3007814810395 | 4211 |
| 7815 | 3007815962729 | 4212 |
| 7816 | 3007816797117 | 4212 |
| 7817 | 3007817180422 | 4212 |
| 7818 | 3007818984659 | 4212 |
| 7819 | 3007819989856 | 4214 |
| 7820 | 3007820933818 | 4215 |
| 7821 | 3007821497486 | 4217 |
| 7822 | 3007822283015 | 4217 |
| 7823 | 3007823920367 | 4217 |
| 7824 | 3007824382704 | 4217 |
| 7825 | 3007825701546 | 4219 |
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;