Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,076–3,100 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3076 | 3003076475336 | 1751 |
| 3077 | 3003077448159 | 1751 |
| 3078 | 3003078117645 | 1752 |
| 3079 | 3003079696791 | 1752 |
| 3080 | 3003080564783 | 1752 |
| 3081 | 3003081201065 | 1754 |
| 3082 | 3003082788598 | 1754 |
| 3083 | 3003083258681 | 1754 |
| 3084 | 3003084339455 | 1754 |
| 3085 | 3003085792690 | 1754 |
| 3086 | 3003086905246 | 1754 |
| 3087 | 3003087546909 | 1754 |
| 3088 | 3003088377266 | 1754 |
| 3089 | 3003089819564 | 1754 |
| 3090 | 3003090583397 | 1754 |
| 3091 | 3003091304274 | 1754 |
| 3092 | 3003092561134 | 1754 |
| 3093 | 3003093729949 | 1754 |
| 3094 | 3003094526071 | 1754 |
| 3095 | 3003095244994 | 1754 |
| 3096 | 3003096580941 | 1754 |
| 3097 | 3003097783395 | 1754 |
| 3098 | 3003098679326 | 1754 |
| 3099 | 3003099858968 | 1754 |
| 3100 | 3003100206718 | 1754 |
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;