Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,251–9,275 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9251 | 3009251974841 | 4974 |
| 9252 | 3009252955136 | 4974 |
| 9253 | 3009253282166 | 4974 |
| 9254 | 3009254611022 | 4974 |
| 9255 | 3009255561674 | 4974 |
| 9256 | 3009256756540 | 4974 |
| 9257 | 3009257528834 | 4974 |
| 9258 | 3009258139702 | 4974 |
| 9259 | 3009259628295 | 4974 |
| 9260 | 3009260769920 | 4974 |
| 9261 | 3009261719701 | 4974 |
| 9262 | 3009262756726 | 4974 |
| 9263 | 3009263002561 | 4974 |
| 9264 | 3009264061038 | 4974 |
| 9265 | 3009265968166 | 4974 |
| 9266 | 3009266099779 | 4974 |
| 9267 | 3009267664320 | 4974 |
| 9268 | 3009268082175 | 4974 |
| 9269 | 3009269461035 | 4974 |
| 9270 | 3009270822148 | 4974 |
| 9271 | 3009271392163 | 4974 |
| 9272 | 3009272703187 | 4974 |
| 9273 | 3009273945564 | 4974 |
| 9274 | 3009274376507 | 4974 |
| 9275 | 3009275595483 | 4974 |
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;