Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,926–2,950 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2926 | 3002926700236 | 1664 |
| 2927 | 3002927054803 | 1665 |
| 2928 | 3002928056308 | 1665 |
| 2929 | 3002929192534 | 1666 |
| 2930 | 3002930526760 | 1666 |
| 2931 | 3002931043467 | 1666 |
| 2932 | 3002932197640 | 1666 |
| 2933 | 3002933243058 | 1668 |
| 2934 | 3002934019586 | 1668 |
| 2935 | 3002935089846 | 1671 |
| 2936 | 3002936016662 | 1671 |
| 2937 | 3002937493727 | 1672 |
| 2938 | 3002938703293 | 1672 |
| 2939 | 3002939157867 | 1672 |
| 2940 | 3002940043667 | 1674 |
| 2941 | 3002941343941 | 1675 |
| 2942 | 3002942729532 | 1677 |
| 2943 | 3002943453162 | 1677 |
| 2944 | 3002944825394 | 1680 |
| 2945 | 3002945004118 | 1680 |
| 2946 | 3002946224097 | 1683 |
| 2947 | 3002947006275 | 1683 |
| 2948 | 3002948013706 | 1683 |
| 2949 | 3002949762620 | 1683 |
| 2950 | 3002950911191 | 1684 |
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;