Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,526–8,550 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8526 | 3008526340016 | 4621 |
| 8527 | 3008527310361 | 4622 |
| 8528 | 3008528113483 | 4623 |
| 8529 | 3008529411422 | 4624 |
| 8530 | 3008530264384 | 4624 |
| 8531 | 3008531342636 | 4624 |
| 8532 | 3008532691946 | 4625 |
| 8533 | 3008533841847 | 4625 |
| 8534 | 3008534925769 | 4626 |
| 8535 | 3008535649800 | 4626 |
| 8536 | 3008536241280 | 4626 |
| 8537 | 3008537624822 | 4626 |
| 8538 | 3008538331202 | 4626 |
| 8539 | 3008539648754 | 4627 |
| 8540 | 3008540479530 | 4627 |
| 8541 | 3008541009342 | 4627 |
| 8542 | 3008542354390 | 4628 |
| 8543 | 3008543837342 | 4628 |
| 8544 | 3008544808515 | 4628 |
| 8545 | 3008545620382 | 4628 |
| 8546 | 3008546890498 | 4630 |
| 8547 | 3008547653455 | 4630 |
| 8548 | 3008548312961 | 4630 |
| 8549 | 3008549402078 | 4631 |
| 8550 | 3008550312362 | 4634 |
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;