Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 6,326–6,350 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 6326 | 3006326098779 | 3493 |
| 6327 | 3006327154468 | 3494 |
| 6328 | 3006328047823 | 3495 |
| 6329 | 3006329507981 | 3497 |
| 6330 | 3006330834918 | 3497 |
| 6331 | 3006331772565 | 3497 |
| 6332 | 3006332397727 | 3498 |
| 6333 | 3006333269286 | 3498 |
| 6334 | 3006334570412 | 3498 |
| 6335 | 3006335054239 | 3498 |
| 6336 | 3006336383767 | 3498 |
| 6337 | 3006337401254 | 3500 |
| 6338 | 3006338327093 | 3501 |
| 6339 | 3006339266593 | 3502 |
| 6340 | 3006340759217 | 3503 |
| 6341 | 3006341922388 | 3503 |
| 6342 | 3006342562097 | 3504 |
| 6343 | 3006343002828 | 3505 |
| 6344 | 3006344993817 | 3505 |
| 6345 | 3006345743308 | 3507 |
| 6346 | 3006346795513 | 3508 |
| 6347 | 3006347260434 | 3508 |
| 6348 | 3006348328116 | 3508 |
| 6349 | 3006349047875 | 3508 |
| 6350 | 3006350415654 | 3510 |
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;