Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,326–4,350 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4326 | 3004326502741 | 2408 |
| 4327 | 3004327214705 | 2408 |
| 4328 | 3004328053057 | 2409 |
| 4329 | 3004329730043 | 2409 |
| 4330 | 3004330005485 | 2409 |
| 4331 | 3004331170819 | 2409 |
| 4332 | 3004332458092 | 2409 |
| 4333 | 3004333095877 | 2410 |
| 4334 | 3004334680922 | 2413 |
| 4335 | 3004335469688 | 2413 |
| 4336 | 3004336084255 | 2413 |
| 4337 | 3004337038611 | 2413 |
| 4338 | 3004338522758 | 2414 |
| 4339 | 3004339217123 | 2414 |
| 4340 | 3004340157426 | 2414 |
| 4341 | 3004341506103 | 2416 |
| 4342 | 3004342874812 | 2416 |
| 4343 | 3004343773107 | 2417 |
| 4344 | 3004344165944 | 2418 |
| 4345 | 3004345737083 | 2418 |
| 4346 | 3004346909457 | 2419 |
| 4347 | 3004347873527 | 2419 |
| 4348 | 3004348805679 | 2420 |
| 4349 | 3004349613306 | 2420 |
| 4350 | 3004350529742 | 2422 |
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;