Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,151–5,175 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5151 | 3005151074429 | 2843 |
| 5152 | 3005152608477 | 2843 |
| 5153 | 3005153776613 | 2843 |
| 5154 | 3005154916940 | 2843 |
| 5155 | 3005155233557 | 2843 |
| 5156 | 3005156141536 | 2843 |
| 5157 | 3005157509708 | 2843 |
| 5158 | 3005158125135 | 2843 |
| 5159 | 3005159656833 | 2843 |
| 5160 | 3005160799203 | 2843 |
| 5161 | 3005161000405 | 2843 |
| 5162 | 3005162360425 | 2843 |
| 5163 | 3005163446458 | 2843 |
| 5164 | 3005164947315 | 2843 |
| 5165 | 3005165523428 | 2843 |
| 5166 | 3005166806404 | 2843 |
| 5167 | 3005167299308 | 2843 |
| 5168 | 3005168032598 | 2843 |
| 5169 | 3005169460818 | 2843 |
| 5170 | 3005170821281 | 2843 |
| 5171 | 3005171622209 | 2843 |
| 5172 | 3005172284297 | 2843 |
| 5173 | 3005173368574 | 2843 |
| 5174 | 3005174992371 | 2843 |
| 5175 | 3005175874317 | 2843 |
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;