Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,026–8,050 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8026 | 3008026891829 | 4289 |
| 8027 | 3008027887480 | 4289 |
| 8028 | 3008028156183 | 4289 |
| 8029 | 3008029674333 | 4289 |
| 8030 | 3008030505773 | 4289 |
| 8031 | 3008031799957 | 4289 |
| 8032 | 3008032752334 | 4289 |
| 8033 | 3008033239141 | 4289 |
| 8034 | 3008034484132 | 4289 |
| 8035 | 3008035818937 | 4291 |
| 8036 | 3008036547978 | 4291 |
| 8037 | 3008037900127 | 4292 |
| 8038 | 3008038840968 | 4293 |
| 8039 | 3008039068132 | 4293 |
| 8040 | 3008040167203 | 4293 |
| 8041 | 3008041748772 | 4294 |
| 8042 | 3008042697703 | 4294 |
| 8043 | 3008043490550 | 4295 |
| 8044 | 3008044588588 | 4295 |
| 8045 | 3008045984157 | 4296 |
| 8046 | 3008046490037 | 4297 |
| 8047 | 3008047715522 | 4297 |
| 8048 | 3008048627277 | 4299 |
| 8049 | 3008049627616 | 4299 |
| 8050 | 3008050061090 | 4300 |
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;