Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,026–9,050 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9026 | 3009026513225 | 4888 |
| 9027 | 3009027346773 | 4888 |
| 9028 | 3009028290695 | 4888 |
| 9029 | 3009029981178 | 4888 |
| 9030 | 3009030299866 | 4888 |
| 9031 | 3009031444772 | 4888 |
| 9032 | 3009032401107 | 4888 |
| 9033 | 3009033768204 | 4888 |
| 9034 | 3009034116824 | 4888 |
| 9035 | 3009035299952 | 4888 |
| 9036 | 3009036216665 | 4888 |
| 9037 | 3009037982344 | 4888 |
| 9038 | 3009038210123 | 4888 |
| 9039 | 3009039730494 | 4888 |
| 9040 | 3009040040181 | 4888 |
| 9041 | 3009041661674 | 4888 |
| 9042 | 3009042038054 | 4888 |
| 9043 | 3009043945911 | 4888 |
| 9044 | 3009044387517 | 4888 |
| 9045 | 3009045771126 | 4888 |
| 9046 | 3009046849741 | 4888 |
| 9047 | 3009047013542 | 4888 |
| 9048 | 3009048762717 | 4888 |
| 9049 | 3009049016386 | 4888 |
| 9050 | 3009050141890 | 4888 |
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;