Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,176–3,200 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3176 | 3003176548920 | 1780 |
| 3177 | 3003177574636 | 1781 |
| 3178 | 3003178182823 | 1781 |
| 3179 | 3003179229965 | 1782 |
| 3180 | 3003180929977 | 1783 |
| 3181 | 3003181509038 | 1783 |
| 3182 | 3003182782155 | 1786 |
| 3183 | 3003183167339 | 1787 |
| 3184 | 3003184974213 | 1787 |
| 3185 | 3003185943994 | 1787 |
| 3186 | 3003186642663 | 1788 |
| 3187 | 3003187958722 | 1788 |
| 3188 | 3003188159285 | 1788 |
| 3189 | 3003189051650 | 1788 |
| 3190 | 3003190535266 | 1788 |
| 3191 | 3003191372648 | 1788 |
| 3192 | 3003192233027 | 1788 |
| 3193 | 3003193471811 | 1788 |
| 3194 | 3003194582054 | 1788 |
| 3195 | 3003195506329 | 1788 |
| 3196 | 3003196981394 | 1788 |
| 3197 | 3003197879014 | 1788 |
| 3198 | 3003198613378 | 1788 |
| 3199 | 3003199309958 | 1788 |
| 3200 | 3003200595097 | 1788 |
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;