Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,676–4,700 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4676 | 3004676247322 | 2591 |
| 4677 | 3004677155880 | 2591 |
| 4678 | 3004678497454 | 2591 |
| 4679 | 3004679983957 | 2591 |
| 4680 | 3004680399637 | 2593 |
| 4681 | 3004681039224 | 2593 |
| 4682 | 3004682565977 | 2593 |
| 4683 | 3004683398809 | 2594 |
| 4684 | 3004684573662 | 2596 |
| 4685 | 3004685588773 | 2596 |
| 4686 | 3004686758024 | 2596 |
| 4687 | 3004687123325 | 2596 |
| 4688 | 3004688674364 | 2596 |
| 4689 | 3004689727634 | 2596 |
| 4690 | 3004690885906 | 2596 |
| 4691 | 3004691012335 | 2596 |
| 4692 | 3004692439580 | 2596 |
| 4693 | 3004693733606 | 2596 |
| 4694 | 3004694603337 | 2596 |
| 4695 | 3004695473796 | 2596 |
| 4696 | 3004696389141 | 2596 |
| 4697 | 3004697497958 | 2596 |
| 4698 | 3004698831857 | 2596 |
| 4699 | 3004699117135 | 2596 |
| 4700 | 3004700828732 | 2596 |
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;