Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,526–9,550 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9526 | 3009526609795 | 5151 |
| 9527 | 3009527854186 | 5152 |
| 9528 | 3009528993574 | 5154 |
| 9529 | 3009529252964 | 5154 |
| 9530 | 3009530368237 | 5155 |
| 9531 | 3009531470756 | 5155 |
| 9532 | 3009532881819 | 5156 |
| 9533 | 3009533080731 | 5158 |
| 9534 | 3009534703615 | 5158 |
| 9535 | 3009535002948 | 5163 |
| 9536 | 3009536426089 | 5164 |
| 9537 | 3009537008780 | 5165 |
| 9538 | 3009538456529 | 5165 |
| 9539 | 3009539299999 | 5167 |
| 9540 | 3009540614830 | 5168 |
| 9541 | 3009541056234 | 5169 |
| 9542 | 3009542121956 | 5170 |
| 9543 | 3009543187390 | 5171 |
| 9544 | 3009544315351 | 5171 |
| 9545 | 3009545971891 | 5172 |
| 9546 | 3009546512419 | 5172 |
| 9547 | 3009547135832 | 5174 |
| 9548 | 3009548499187 | 5174 |
| 9549 | 3009549827548 | 5175 |
| 9550 | 3009550604713 | 5175 |
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;