Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,276–9,300 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9276 | 3009276036058 | 4974 |
| 9277 | 3009277305765 | 4974 |
| 9278 | 3009278850330 | 4974 |
| 9279 | 3009279330993 | 4974 |
| 9280 | 3009280627610 | 4974 |
| 9281 | 3009281775185 | 4974 |
| 9282 | 3009282841468 | 4974 |
| 9283 | 3009283224985 | 4974 |
| 9284 | 3009284567132 | 4974 |
| 9285 | 3009285642026 | 4974 |
| 9286 | 3009286151063 | 4974 |
| 9287 | 3009287974031 | 4974 |
| 9288 | 3009288238729 | 4974 |
| 9289 | 3009289006345 | 4974 |
| 9290 | 3009290844640 | 4974 |
| 9291 | 3009291622554 | 4976 |
| 9292 | 3009292497411 | 4977 |
| 9293 | 3009293046876 | 4978 |
| 9294 | 3009294822920 | 4978 |
| 9295 | 3009295676499 | 4979 |
| 9296 | 3009296369560 | 4982 |
| 9297 | 3009297285621 | 4982 |
| 9298 | 3009298435020 | 4983 |
| 9299 | 3009299556405 | 4983 |
| 9300 | 3009300607606 | 4985 |
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;