Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,176–9,200 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9176 | 3009176089290 | 4957 |
| 9177 | 3009177230485 | 4958 |
| 9178 | 3009178059583 | 4958 |
| 9179 | 3009179957086 | 4959 |
| 9180 | 3009180914405 | 4962 |
| 9181 | 3009181655748 | 4962 |
| 9182 | 3009182918265 | 4964 |
| 9183 | 3009183058006 | 4964 |
| 9184 | 3009184448474 | 4967 |
| 9185 | 3009185840509 | 4967 |
| 9186 | 3009186823457 | 4967 |
| 9187 | 3009187102853 | 4967 |
| 9188 | 3009188394388 | 4967 |
| 9189 | 3009189680903 | 4967 |
| 9190 | 3009190378360 | 4967 |
| 9191 | 3009191381576 | 4967 |
| 9192 | 3009192819715 | 4967 |
| 9193 | 3009193675788 | 4967 |
| 9194 | 3009194441339 | 4967 |
| 9195 | 3009195506671 | 4967 |
| 9196 | 3009196716428 | 4967 |
| 9197 | 3009197957098 | 4967 |
| 9198 | 3009198899825 | 4967 |
| 9199 | 3009199301788 | 4967 |
| 9200 | 3009200340286 | 4967 |
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;