Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,201–3,225 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3201 | 3003201735684 | 1788 |
| 3202 | 3003202182075 | 1788 |
| 3203 | 3003203015979 | 1788 |
| 3204 | 3003204087378 | 1788 |
| 3205 | 3003205726804 | 1788 |
| 3206 | 3003206414149 | 1788 |
| 3207 | 3003207351510 | 1788 |
| 3208 | 3003208319836 | 1788 |
| 3209 | 3003209015717 | 1788 |
| 3210 | 3003210135737 | 1788 |
| 3211 | 3003211706873 | 1788 |
| 3212 | 3003212993162 | 1788 |
| 3213 | 3003213711232 | 1788 |
| 3214 | 3003214787739 | 1788 |
| 3215 | 3003215307907 | 1788 |
| 3216 | 3003216225028 | 1788 |
| 3217 | 3003217331145 | 1788 |
| 3218 | 3003218638647 | 1788 |
| 3219 | 3003219345377 | 1788 |
| 3220 | 3003220553173 | 1788 |
| 3221 | 3003221271297 | 1788 |
| 3222 | 3003222394498 | 1788 |
| 3223 | 3003223584259 | 1788 |
| 3224 | 3003224983152 | 1788 |
| 3225 | 3003225107088 | 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;