Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,751–9,775 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9751 | 3009751686219 | 5337 |
| 9752 | 3009752144243 | 5338 |
| 9753 | 3009753157106 | 5338 |
| 9754 | 3009754905059 | 5339 |
| 9755 | 3009755882042 | 5339 |
| 9756 | 3009756421224 | 5341 |
| 9757 | 3009757248808 | 5341 |
| 9758 | 3009758720061 | 5342 |
| 9759 | 3009759420157 | 5343 |
| 9760 | 3009760730047 | 5343 |
| 9761 | 3009761966493 | 5347 |
| 9762 | 3009762362199 | 5347 |
| 9763 | 3009763570123 | 5351 |
| 9764 | 3009764902644 | 5351 |
| 9765 | 3009765095619 | 5351 |
| 9766 | 3009766909884 | 5355 |
| 9767 | 3009767766855 | 5355 |
| 9768 | 3009768101650 | 5355 |
| 9769 | 3009769137894 | 5358 |
| 9770 | 3009770544476 | 5358 |
| 9771 | 3009771428907 | 5358 |
| 9772 | 3009772676398 | 5358 |
| 9773 | 3009773194642 | 5359 |
| 9774 | 3009774044797 | 5360 |
| 9775 | 3009775450216 | 5361 |
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;