Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 9,301–9,325 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 9301 | 3009301583580 | 4985 |
| 9302 | 3009302886082 | 4987 |
| 9303 | 3009303273519 | 4988 |
| 9304 | 3009304576760 | 4990 |
| 9305 | 3009305585794 | 4990 |
| 9306 | 3009306126683 | 4993 |
| 9307 | 3009307315300 | 4994 |
| 9308 | 3009308353260 | 4994 |
| 9309 | 3009309982838 | 4999 |
| 9310 | 3009310349646 | 4999 |
| 9311 | 3009311103336 | 5000 |
| 9312 | 3009312396927 | 5000 |
| 9313 | 3009313270080 | 5001 |
| 9314 | 3009314629904 | 5001 |
| 9315 | 3009315799165 | 5001 |
| 9316 | 3009316774864 | 5001 |
| 9317 | 3009317800375 | 5001 |
| 9318 | 3009318615112 | 5002 |
| 9319 | 3009319256833 | 5002 |
| 9320 | 3009320753978 | 5003 |
| 9321 | 3009321112807 | 5003 |
| 9322 | 3009322136030 | 5004 |
| 9323 | 3009323510868 | 5005 |
| 9324 | 3009324825312 | 5005 |
| 9325 | 3009325365625 | 5006 |
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;