Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,801–3,825 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3801 | 3003801409302 | 2081 |
| 3802 | 3003802810661 | 2081 |
| 3803 | 3003803436009 | 2081 |
| 3804 | 3003804507331 | 2081 |
| 3805 | 3003805866727 | 2081 |
| 3806 | 3003806770204 | 2081 |
| 3807 | 3003807355694 | 2081 |
| 3808 | 3003808421988 | 2081 |
| 3809 | 3003809402736 | 2081 |
| 3810 | 3003810471800 | 2081 |
| 3811 | 3003811383452 | 2081 |
| 3812 | 3003812855702 | 2081 |
| 3813 | 3003813364000 | 2083 |
| 3814 | 3003814488899 | 2084 |
| 3815 | 3003815241901 | 2085 |
| 3816 | 3003816856776 | 2085 |
| 3817 | 3003817121417 | 2085 |
| 3818 | 3003818627833 | 2085 |
| 3819 | 3003819966992 | 2086 |
| 3820 | 3003820829291 | 2086 |
| 3821 | 3003821484821 | 2086 |
| 3822 | 3003822811740 | 2086 |
| 3823 | 3003823029661 | 2086 |
| 3824 | 3003824247130 | 2087 |
| 3825 | 3003825279782 | 2087 |
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;