Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,551–7,575 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7551 | 3007551187381 | 4078 |
| 7552 | 3007552275237 | 4078 |
| 7553 | 3007553148115 | 4078 |
| 7554 | 3007554216460 | 4078 |
| 7555 | 3007555951219 | 4078 |
| 7556 | 3007556565505 | 4078 |
| 7557 | 3007557039895 | 4078 |
| 7558 | 3007558888983 | 4078 |
| 7559 | 3007559818474 | 4078 |
| 7560 | 3007560166879 | 4078 |
| 7561 | 3007561769517 | 4078 |
| 7562 | 3007562376531 | 4078 |
| 7563 | 3007563847887 | 4078 |
| 7564 | 3007564653218 | 4078 |
| 7565 | 3007565551322 | 4078 |
| 7566 | 3007566533039 | 4078 |
| 7567 | 3007567308693 | 4078 |
| 7568 | 3007568793402 | 4078 |
| 7569 | 3007569702208 | 4078 |
| 7570 | 3007570254953 | 4078 |
| 7571 | 3007571523785 | 4078 |
| 7572 | 3007572671906 | 4078 |
| 7573 | 3007573176132 | 4078 |
| 7574 | 3007574465003 | 4079 |
| 7575 | 3007575380368 | 4079 |
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;