Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,176–7,200 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7176 | 3007176108487 | 3899 |
| 7177 | 3007177073708 | 3899 |
| 7178 | 3007178979675 | 3900 |
| 7179 | 3007179511745 | 3900 |
| 7180 | 3007180390049 | 3901 |
| 7181 | 3007181322070 | 3901 |
| 7182 | 3007182914149 | 3903 |
| 7183 | 3007183677758 | 3903 |
| 7184 | 3007184011073 | 3903 |
| 7185 | 3007185425322 | 3904 |
| 7186 | 3007186088822 | 3904 |
| 7187 | 3007187776956 | 3904 |
| 7188 | 3007188640964 | 3904 |
| 7189 | 3007189886287 | 3904 |
| 7190 | 3007190321242 | 3907 |
| 7191 | 3007191818012 | 3907 |
| 7192 | 3007192160888 | 3909 |
| 7193 | 3007193283291 | 3909 |
| 7194 | 3007194210849 | 3909 |
| 7195 | 3007195046494 | 3909 |
| 7196 | 3007196466933 | 3911 |
| 7197 | 3007197767559 | 3911 |
| 7198 | 3007198677571 | 3912 |
| 7199 | 3007199343795 | 3913 |
| 7200 | 3007200235523 | 3913 |
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;