Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,526–4,550 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4526 | 3004526230253 | 2516 |
| 4527 | 3004527596306 | 2519 |
| 4528 | 3004528708580 | 2519 |
| 4529 | 3004529503353 | 2519 |
| 4530 | 3004530657620 | 2519 |
| 4531 | 3004531678559 | 2520 |
| 4532 | 3004532560323 | 2522 |
| 4533 | 3004533980332 | 2522 |
| 4534 | 3004534486930 | 2523 |
| 4535 | 3004535220926 | 2523 |
| 4536 | 3004536014630 | 2523 |
| 4537 | 3004537703199 | 2525 |
| 4538 | 3004538236289 | 2525 |
| 4539 | 3004539032634 | 2525 |
| 4540 | 3004540148429 | 2527 |
| 4541 | 3004541014224 | 2527 |
| 4542 | 3004542923886 | 2528 |
| 4543 | 3004543984443 | 2528 |
| 4544 | 3004544273123 | 2528 |
| 4545 | 3004545263610 | 2529 |
| 4546 | 3004546034325 | 2529 |
| 4547 | 3004547387449 | 2529 |
| 4548 | 3004548824423 | 2529 |
| 4549 | 3004549815637 | 2531 |
| 4550 | 3004550498271 | 2532 |
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;