Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,176–4,200 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4176 | 3004176753671 | 2326 |
| 4177 | 3004177919834 | 2326 |
| 4178 | 3004178104594 | 2327 |
| 4179 | 3004179841752 | 2327 |
| 4180 | 3004180084513 | 2328 |
| 4181 | 3004181131359 | 2329 |
| 4182 | 3004182690817 | 2330 |
| 4183 | 3004183167630 | 2330 |
| 4184 | 3004184121265 | 2331 |
| 4185 | 3004185425190 | 2331 |
| 4186 | 3004186178347 | 2332 |
| 4187 | 3004187425817 | 2334 |
| 4188 | 3004188406507 | 2334 |
| 4189 | 3004189628064 | 2334 |
| 4190 | 3004190307032 | 2334 |
| 4191 | 3004191337969 | 2334 |
| 4192 | 3004192644863 | 2335 |
| 4193 | 3004193908770 | 2340 |
| 4194 | 3004194606449 | 2341 |
| 4195 | 3004195873878 | 2341 |
| 4196 | 3004196831289 | 2343 |
| 4197 | 3004197734114 | 2343 |
| 4198 | 3004198040112 | 2343 |
| 4199 | 3004199058227 | 2343 |
| 4200 | 3004200704772 | 2343 |
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;