Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,151–3,175 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3151 | 3003151027649 | 1766 |
| 3152 | 3003152893455 | 1768 |
| 3153 | 3003153921199 | 1768 |
| 3154 | 3003154828202 | 1768 |
| 3155 | 3003155589347 | 1768 |
| 3156 | 3003156182862 | 1769 |
| 3157 | 3003157868270 | 1770 |
| 3158 | 3003158081610 | 1770 |
| 3159 | 3003159026735 | 1770 |
| 3160 | 3003160561131 | 1770 |
| 3161 | 3003161893253 | 1771 |
| 3162 | 3003162412085 | 1771 |
| 3163 | 3003163452820 | 1771 |
| 3164 | 3003164440332 | 1773 |
| 3165 | 3003165224680 | 1773 |
| 3166 | 3003166947339 | 1774 |
| 3167 | 3003167412629 | 1776 |
| 3168 | 3003168682775 | 1777 |
| 3169 | 3003169471894 | 1777 |
| 3170 | 3003170296970 | 1777 |
| 3171 | 3003171002027 | 1777 |
| 3172 | 3003172200863 | 1778 |
| 3173 | 3003173360849 | 1778 |
| 3174 | 3003174918900 | 1780 |
| 3175 | 3003175630824 | 1780 |
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;