Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 8,651–8,675 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 8651 | 3008651465331 | 4693 |
| 8652 | 3008652288983 | 4695 |
| 8653 | 3008653741041 | 4695 |
| 8654 | 3008654620162 | 4698 |
| 8655 | 3008655346146 | 4699 |
| 8656 | 3008656996598 | 4701 |
| 8657 | 3008657994176 | 4701 |
| 8658 | 3008658371870 | 4701 |
| 8659 | 3008659011153 | 4703 |
| 8660 | 3008660683991 | 4703 |
| 8661 | 3008661438240 | 4703 |
| 8662 | 3008662328922 | 4703 |
| 8663 | 3008663602353 | 4704 |
| 8664 | 3008664444490 | 4704 |
| 8665 | 3008665924755 | 4706 |
| 8666 | 3008666382633 | 4706 |
| 8667 | 3008667344907 | 4706 |
| 8668 | 3008668194452 | 4706 |
| 8669 | 3008669115306 | 4707 |
| 8670 | 3008670695972 | 4708 |
| 8671 | 3008671189515 | 4708 |
| 8672 | 3008672548090 | 4708 |
| 8673 | 3008673655888 | 4709 |
| 8674 | 3008674500834 | 4711 |
| 8675 | 3008675539211 | 4711 |
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;