Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,926–6,950 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6926 | 3006926567422 | 3815 |
| 6927 | 3006927468719 | 3816 |
| 6928 | 3006928952584 | 3817 |
| 6929 | 3006929311242 | 3817 |
| 6930 | 3006930470910 | 3817 |
| 6931 | 3006931402323 | 3818 |
| 6932 | 3006932192340 | 3818 |
| 6933 | 3006933802795 | 3819 |
| 6934 | 3006934653231 | 3819 |
| 6935 | 3006935990835 | 3820 |
| 6936 | 3006936950331 | 3820 |
| 6937 | 3006937865063 | 3821 |
| 6938 | 3006938380197 | 3821 |
| 6939 | 3006939571318 | 3821 |
| 6940 | 3006940647679 | 3821 |
| 6941 | 3006941035590 | 3823 |
| 6942 | 3006942451096 | 3823 |
| 6943 | 3006943069223 | 3823 |
| 6944 | 3006944632655 | 3825 |
| 6945 | 3006945339698 | 3825 |
| 6946 | 3006946707260 | 3825 |
| 6947 | 3006947595535 | 3826 |
| 6948 | 3006948416149 | 3827 |
| 6949 | 3006949234273 | 3828 |
| 6950 | 3006950959246 | 3828 |
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;