Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,876–5,900 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5876 | 3005876973786 | 3283 |
| 5877 | 3005877891143 | 3283 |
| 5878 | 3005878045290 | 3284 |
| 5879 | 3005879883201 | 3284 |
| 5880 | 3005880085665 | 3284 |
| 5881 | 3005881334224 | 3284 |
| 5882 | 3005882677703 | 3285 |
| 5883 | 3005883372634 | 3285 |
| 5884 | 3005884996496 | 3285 |
| 5885 | 3005885294351 | 3286 |
| 5886 | 3005886867811 | 3288 |
| 5887 | 3005887721190 | 3288 |
| 5888 | 3005888094498 | 3288 |
| 5889 | 3005889175019 | 3288 |
| 5890 | 3005890042040 | 3288 |
| 5891 | 3005891018609 | 3289 |
| 5892 | 3005892026069 | 3289 |
| 5893 | 3005893399482 | 3293 |
| 5894 | 3005894844705 | 3295 |
| 5895 | 3005895008600 | 3295 |
| 5896 | 3005896919934 | 3296 |
| 5897 | 3005897790943 | 3296 |
| 5898 | 3005898625835 | 3296 |
| 5899 | 3005899010275 | 3296 |
| 5900 | 3005900060450 | 3296 |
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;