Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,201–9,225 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9201 | 3009201845336 | 4967 |
| 9202 | 3009202419624 | 4967 |
| 9203 | 3009203379026 | 4967 |
| 9204 | 3009204354879 | 4967 |
| 9205 | 3009205128481 | 4967 |
| 9206 | 3009206948845 | 4967 |
| 9207 | 3009207602822 | 4967 |
| 9208 | 3009208425884 | 4967 |
| 9209 | 3009209299261 | 4967 |
| 9210 | 3009210094354 | 4967 |
| 9211 | 3009211271374 | 4967 |
| 9212 | 3009212310981 | 4967 |
| 9213 | 3009213068493 | 4967 |
| 9214 | 3009214397534 | 4967 |
| 9215 | 3009215045501 | 4967 |
| 9216 | 3009216088873 | 4967 |
| 9217 | 3009217652491 | 4967 |
| 9218 | 3009218233326 | 4967 |
| 9219 | 3009219719173 | 4967 |
| 9220 | 3009220886388 | 4967 |
| 9221 | 3009221900798 | 4967 |
| 9222 | 3009222563857 | 4967 |
| 9223 | 3009223967767 | 4967 |
| 9224 | 3009224609139 | 4967 |
| 9225 | 3009225472267 | 4967 |
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;