Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,276–4,300 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4276 | 3004276275062 | 2367 |
| 4277 | 3004277067990 | 2368 |
| 4278 | 3004278476948 | 2369 |
| 4279 | 3004279797047 | 2369 |
| 4280 | 3004280655070 | 2370 |
| 4281 | 3004281699801 | 2370 |
| 4282 | 3004282892548 | 2370 |
| 4283 | 3004283597411 | 2373 |
| 4284 | 3004284218641 | 2373 |
| 4285 | 3004285805999 | 2373 |
| 4286 | 3004286333004 | 2374 |
| 4287 | 3004287100927 | 2374 |
| 4288 | 3004288047821 | 2374 |
| 4289 | 3004289569036 | 2375 |
| 4290 | 3004290399811 | 2375 |
| 4291 | 3004291643603 | 2375 |
| 4292 | 3004292982891 | 2375 |
| 4293 | 3004293989905 | 2375 |
| 4294 | 3004294603275 | 2376 |
| 4295 | 3004295730068 | 2378 |
| 4296 | 3004296677906 | 2381 |
| 4297 | 3004297750594 | 2381 |
| 4298 | 3004298408890 | 2381 |
| 4299 | 3004299236121 | 2382 |
| 4300 | 3004300521994 | 2384 |
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;