Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,301–2,325 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2301 | 3002301188176 | 1263 |
| 2302 | 3002302207585 | 1265 |
| 2303 | 3002303043658 | 1265 |
| 2304 | 3002304434219 | 1267 |
| 2305 | 3002305839511 | 1267 |
| 2306 | 3002306349970 | 1267 |
| 2307 | 3002307093408 | 1268 |
| 2308 | 3002308640219 | 1268 |
| 2309 | 3002309389697 | 1270 |
| 2310 | 3002310810139 | 1270 |
| 2311 | 3002311822232 | 1271 |
| 2312 | 3002312525726 | 1271 |
| 2313 | 3002313642966 | 1272 |
| 2314 | 3002314773372 | 1272 |
| 2315 | 3002315098799 | 1272 |
| 2316 | 3002316482679 | 1272 |
| 2317 | 3002317766204 | 1272 |
| 2318 | 3002318687094 | 1273 |
| 2319 | 3002319340966 | 1275 |
| 2320 | 3002320413893 | 1276 |
| 2321 | 3002321223690 | 1276 |
| 2322 | 3002322951617 | 1276 |
| 2323 | 3002323992215 | 1276 |
| 2324 | 3002324840008 | 1277 |
| 2325 | 3002325488588 | 1277 |
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;