Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,226–3,250 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3226 | 3003226112197 | 1788 |
| 3227 | 3003227601047 | 1788 |
| 3228 | 3003228229309 | 1788 |
| 3229 | 3003229361159 | 1788 |
| 3230 | 3003230097886 | 1788 |
| 3231 | 3003231020065 | 1788 |
| 3232 | 3003232866489 | 1788 |
| 3233 | 3003233168911 | 1788 |
| 3234 | 3003234416978 | 1788 |
| 3235 | 3003235467545 | 1788 |
| 3236 | 3003236177072 | 1788 |
| 3237 | 3003237578443 | 1788 |
| 3238 | 3003238189153 | 1788 |
| 3239 | 3003239006464 | 1789 |
| 3240 | 3003240802879 | 1791 |
| 3241 | 3003241960430 | 1791 |
| 3242 | 3003242777983 | 1792 |
| 3243 | 3003243474053 | 1792 |
| 3244 | 3003244091918 | 1793 |
| 3245 | 3003245865677 | 1793 |
| 3246 | 3003246044040 | 1793 |
| 3247 | 3003247503001 | 1793 |
| 3248 | 3003248503780 | 1794 |
| 3249 | 3003249909336 | 1794 |
| 3250 | 3003250506733 | 1794 |
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;