Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,151–8,175 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8151 | 3008151346782 | 4369 |
| 8152 | 3008152616416 | 4369 |
| 8153 | 3008153710476 | 4371 |
| 8154 | 3008154047287 | 4371 |
| 8155 | 3008155325362 | 4372 |
| 8156 | 3008156706852 | 4373 |
| 8157 | 3008157049174 | 4374 |
| 8158 | 3008158255345 | 4374 |
| 8159 | 3008159081022 | 4375 |
| 8160 | 3008160105730 | 4375 |
| 8161 | 3008161125604 | 4376 |
| 8162 | 3008162876943 | 4376 |
| 8163 | 3008163005983 | 4377 |
| 8164 | 3008164893122 | 4379 |
| 8165 | 3008165023292 | 4379 |
| 8166 | 3008166049299 | 4379 |
| 8167 | 3008167687801 | 4379 |
| 8168 | 3008168549141 | 4381 |
| 8169 | 3008169139426 | 4381 |
| 8170 | 3008170587168 | 4381 |
| 8171 | 3008171214732 | 4381 |
| 8172 | 3008172380789 | 4381 |
| 8173 | 3008173770173 | 4383 |
| 8174 | 3008174561243 | 4383 |
| 8175 | 3008175753173 | 4383 |
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;