Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,501–9,525 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9501 | 3009501599865 | 5131 |
| 9502 | 3009502827230 | 5132 |
| 9503 | 3009503020578 | 5132 |
| 9504 | 3009504573064 | 5132 |
| 9505 | 3009505275075 | 5132 |
| 9506 | 3009506312858 | 5133 |
| 9507 | 3009507306873 | 5133 |
| 9508 | 3009508936816 | 5137 |
| 9509 | 3009509126708 | 5137 |
| 9510 | 3009510625288 | 5138 |
| 9511 | 3009511049472 | 5138 |
| 9512 | 3009512652817 | 5139 |
| 9513 | 3009513966858 | 5139 |
| 9514 | 3009514864477 | 5139 |
| 9515 | 3009515944647 | 5140 |
| 9516 | 3009516621858 | 5140 |
| 9517 | 3009517255128 | 5142 |
| 9518 | 3009518444113 | 5142 |
| 9519 | 3009519741847 | 5145 |
| 9520 | 3009520840327 | 5145 |
| 9521 | 3009521240178 | 5146 |
| 9522 | 3009522185046 | 5146 |
| 9523 | 3009523634581 | 5146 |
| 9524 | 3009524965179 | 5148 |
| 9525 | 3009525935632 | 5148 |
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;