Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,276–3,300 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3276 | 3003276976123 | 1797 |
| 3277 | 3003277764122 | 1797 |
| 3278 | 3003278959026 | 1797 |
| 3279 | 3003279648494 | 1797 |
| 3280 | 3003280037428 | 1797 |
| 3281 | 3003281817501 | 1797 |
| 3282 | 3003282471808 | 1797 |
| 3283 | 3003283315433 | 1797 |
| 3284 | 3003284082674 | 1797 |
| 3285 | 3003285398026 | 1797 |
| 3286 | 3003286936615 | 1797 |
| 3287 | 3003287668189 | 1797 |
| 3288 | 3003288300681 | 1797 |
| 3289 | 3003289237274 | 1797 |
| 3290 | 3003290244470 | 1797 |
| 3291 | 3003291755268 | 1797 |
| 3292 | 3003292154521 | 1797 |
| 3293 | 3003293313684 | 1797 |
| 3294 | 3003294334773 | 1797 |
| 3295 | 3003295236716 | 1797 |
| 3296 | 3003296042867 | 1797 |
| 3297 | 3003297655556 | 1797 |
| 3298 | 3003298923601 | 1797 |
| 3299 | 3003299080570 | 1797 |
| 3300 | 3003300699437 | 1797 |
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;