Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,451–5,475 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5451 | 3005451444656 | 3022 |
| 5452 | 3005452793018 | 3023 |
| 5453 | 3005453002863 | 3023 |
| 5454 | 3005454642155 | 3024 |
| 5455 | 3005455030929 | 3024 |
| 5456 | 3005456689327 | 3024 |
| 5457 | 3005457330758 | 3026 |
| 5458 | 3005458149558 | 3026 |
| 5459 | 3005459884635 | 3026 |
| 5460 | 3005460269206 | 3026 |
| 5461 | 3005461862048 | 3027 |
| 5462 | 3005462456292 | 3028 |
| 5463 | 3005463214429 | 3028 |
| 5464 | 3005464132963 | 3033 |
| 5465 | 3005465042704 | 3033 |
| 5466 | 3005466685783 | 3034 |
| 5467 | 3005467077698 | 3034 |
| 5468 | 3005468922568 | 3035 |
| 5469 | 3005469357011 | 3035 |
| 5470 | 3005470973248 | 3038 |
| 5471 | 3005471743490 | 3039 |
| 5472 | 3005472584415 | 3040 |
| 5473 | 3005473382985 | 3040 |
| 5474 | 3005474058746 | 3041 |
| 5475 | 3005475210578 | 3041 |
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;