Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,301–3,325 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3301 | 3003301327120 | 1797 |
| 3302 | 3003302837058 | 1798 |
| 3303 | 3003303842538 | 1799 |
| 3304 | 3003304540040 | 1799 |
| 3305 | 3003305298847 | 1799 |
| 3306 | 3003306431291 | 1799 |
| 3307 | 3003307441539 | 1799 |
| 3308 | 3003308656081 | 1804 |
| 3309 | 3003309061600 | 1804 |
| 3310 | 3003310565951 | 1804 |
| 3311 | 3003311409605 | 1805 |
| 3312 | 3003312315326 | 1806 |
| 3313 | 3003313463882 | 1806 |
| 3314 | 3003314734894 | 1810 |
| 3315 | 3003315075408 | 1811 |
| 3316 | 3003316272569 | 1811 |
| 3317 | 3003317489878 | 1812 |
| 3318 | 3003318386017 | 1812 |
| 3319 | 3003319556384 | 1813 |
| 3320 | 3003320756761 | 1815 |
| 3321 | 3003321887451 | 1815 |
| 3322 | 3003322192397 | 1818 |
| 3323 | 3003323396511 | 1820 |
| 3324 | 3003324980761 | 1820 |
| 3325 | 3003325169566 | 1822 |
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;