Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,051–9,075 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9051 | 3009051678160 | 4888 |
| 9052 | 3009052876198 | 4888 |
| 9053 | 3009053975163 | 4888 |
| 9054 | 3009054918946 | 4888 |
| 9055 | 3009055884799 | 4888 |
| 9056 | 3009056063999 | 4888 |
| 9057 | 3009057186909 | 4888 |
| 9058 | 3009058412530 | 4888 |
| 9059 | 3009059895808 | 4888 |
| 9060 | 3009060765201 | 4888 |
| 9061 | 3009061418348 | 4888 |
| 9062 | 3009062747559 | 4888 |
| 9063 | 3009063909758 | 4888 |
| 9064 | 3009064024921 | 4888 |
| 9065 | 3009065090086 | 4888 |
| 9066 | 3009066839322 | 4888 |
| 9067 | 3009067984963 | 4888 |
| 9068 | 3009068507328 | 4888 |
| 9069 | 3009069574014 | 4888 |
| 9070 | 3009070187005 | 4888 |
| 9071 | 3009071533080 | 4888 |
| 9072 | 3009072751358 | 4888 |
| 9073 | 3009073947420 | 4888 |
| 9074 | 3009074836641 | 4888 |
| 9075 | 3009075871765 | 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;