Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,801–5,825 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5801 | 3005801316744 | 3240 |
| 5802 | 3005802274059 | 3241 |
| 5803 | 3005803223307 | 3244 |
| 5804 | 3005804702702 | 3244 |
| 5805 | 3005805712350 | 3244 |
| 5806 | 3005806306261 | 3244 |
| 5807 | 3005807433202 | 3245 |
| 5808 | 3005808353167 | 3245 |
| 5809 | 3005809325726 | 3249 |
| 5810 | 3005810903009 | 3251 |
| 5811 | 3005811451656 | 3252 |
| 5812 | 3005812415236 | 3252 |
| 5813 | 3005813288392 | 3253 |
| 5814 | 3005814733993 | 3253 |
| 5815 | 3005815196239 | 3254 |
| 5816 | 3005816651999 | 3254 |
| 5817 | 3005817758983 | 3256 |
| 5818 | 3005818401137 | 3257 |
| 5819 | 3005819316017 | 3259 |
| 5820 | 3005820727024 | 3259 |
| 5821 | 3005821329689 | 3260 |
| 5822 | 3005822810200 | 3261 |
| 5823 | 3005823594233 | 3264 |
| 5824 | 3005824405156 | 3264 |
| 5825 | 3005825599610 | 3266 |
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;