Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,326–3,350 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3326 | 3003326234359 | 1822 |
| 3327 | 3003327713543 | 1822 |
| 3328 | 3003328940765 | 1822 |
| 3329 | 3003329717787 | 1822 |
| 3330 | 3003330701971 | 1823 |
| 3331 | 3003331622582 | 1823 |
| 3332 | 3003332924345 | 1824 |
| 3333 | 3003333811694 | 1825 |
| 3334 | 3003334225089 | 1825 |
| 3335 | 3003335857259 | 1827 |
| 3336 | 3003336876075 | 1830 |
| 3337 | 3003337560693 | 1831 |
| 3338 | 3003338440833 | 1831 |
| 3339 | 3003339125457 | 1832 |
| 3340 | 3003340027906 | 1833 |
| 3341 | 3003341132138 | 1835 |
| 3342 | 3003342119653 | 1836 |
| 3343 | 3003343368030 | 1836 |
| 3344 | 3003344664794 | 1836 |
| 3345 | 3003345598154 | 1836 |
| 3346 | 3003346020984 | 1836 |
| 3347 | 3003347348009 | 1836 |
| 3348 | 3003348685300 | 1836 |
| 3349 | 3003349754085 | 1836 |
| 3350 | 3003350638384 | 1836 |
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;