Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,651–2,675 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2651 | 3002651472747 | 1504 |
| 2652 | 3002652155269 | 1504 |
| 2653 | 3002653439098 | 1508 |
| 2654 | 3002654257012 | 1509 |
| 2655 | 3002655282921 | 1509 |
| 2656 | 3002656245834 | 1510 |
| 2657 | 3002657945908 | 1510 |
| 2658 | 3002658531400 | 1511 |
| 2659 | 3002659273202 | 1511 |
| 2660 | 3002660502142 | 1511 |
| 2661 | 3002661690712 | 1511 |
| 2662 | 3002662277282 | 1512 |
| 2663 | 3002663769172 | 1512 |
| 2664 | 3002664759921 | 1513 |
| 2665 | 3002665256302 | 1514 |
| 2666 | 3002666650189 | 1514 |
| 2667 | 3002667942640 | 1517 |
| 2668 | 3002668280939 | 1517 |
| 2669 | 3002669959848 | 1518 |
| 2670 | 3002670358824 | 1518 |
| 2671 | 3002671665141 | 1519 |
| 2672 | 3002672777015 | 1519 |
| 2673 | 3002673615661 | 1519 |
| 2674 | 3002674984853 | 1519 |
| 2675 | 3002675108281 | 1519 |
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;