Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,276–7,300 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7276 | 3007276816614 | 3974 |
| 7277 | 3007277669628 | 3975 |
| 7278 | 3007278798170 | 3975 |
| 7279 | 3007279507565 | 3977 |
| 7280 | 3007280106344 | 3978 |
| 7281 | 3007281002971 | 3978 |
| 7282 | 3007282973538 | 3981 |
| 7283 | 3007283499347 | 3983 |
| 7284 | 3007284226578 | 3984 |
| 7285 | 3007285380530 | 3987 |
| 7286 | 3007286350885 | 3987 |
| 7287 | 3007287473175 | 3988 |
| 7288 | 3007288652604 | 3988 |
| 7289 | 3007289595233 | 3990 |
| 7290 | 3007290709097 | 3992 |
| 7291 | 3007291259397 | 3992 |
| 7292 | 3007292179559 | 3993 |
| 7293 | 3007293558040 | 3993 |
| 7294 | 3007294198497 | 3993 |
| 7295 | 3007295264287 | 3993 |
| 7296 | 3007296447269 | 3993 |
| 7297 | 3007297268124 | 3993 |
| 7298 | 3007298840995 | 3993 |
| 7299 | 3007299290985 | 3993 |
| 7300 | 3007300400784 | 3993 |
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;