Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,051–4,075 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4051 | 3004051952374 | 2256 |
| 4052 | 3004052929632 | 2257 |
| 4053 | 3004053814867 | 2257 |
| 4054 | 3004054035002 | 2261 |
| 4055 | 3004055247717 | 2261 |
| 4056 | 3004056722894 | 2262 |
| 4057 | 3004057495030 | 2263 |
| 4058 | 3004058132104 | 2264 |
| 4059 | 3004059611358 | 2266 |
| 4060 | 3004060304886 | 2266 |
| 4061 | 3004061098709 | 2267 |
| 4062 | 3004062934402 | 2268 |
| 4063 | 3004063584583 | 2270 |
| 4064 | 3004064832795 | 2271 |
| 4065 | 3004065574281 | 2271 |
| 4066 | 3004066357210 | 2272 |
| 4067 | 3004067714995 | 2272 |
| 4068 | 3004068064568 | 2272 |
| 4069 | 3004069411284 | 2274 |
| 4070 | 3004070546254 | 2276 |
| 4071 | 3004071034791 | 2276 |
| 4072 | 3004072164330 | 2276 |
| 4073 | 3004073334121 | 2277 |
| 4074 | 3004074678139 | 2277 |
| 4075 | 3004075447912 | 2278 |
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;