Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,851–3,875 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3851 | 3003851902525 | 2110 |
| 3852 | 3003852947171 | 2111 |
| 3853 | 3003853397898 | 2111 |
| 3854 | 3003854162045 | 2112 |
| 3855 | 3003855291617 | 2113 |
| 3856 | 3003856398265 | 2114 |
| 3857 | 3003857003101 | 2114 |
| 3858 | 3003858087213 | 2114 |
| 3859 | 3003859523461 | 2114 |
| 3860 | 3003860544615 | 2114 |
| 3861 | 3003861506114 | 2115 |
| 3862 | 3003862068140 | 2115 |
| 3863 | 3003863372258 | 2115 |
| 3864 | 3003864407907 | 2115 |
| 3865 | 3003865057637 | 2120 |
| 3866 | 3003866458084 | 2120 |
| 3867 | 3003867440124 | 2122 |
| 3868 | 3003868487260 | 2122 |
| 3869 | 3003869731769 | 2122 |
| 3870 | 3003870098582 | 2123 |
| 3871 | 3003871981021 | 2123 |
| 3872 | 3003872755452 | 2124 |
| 3873 | 3003873785073 | 2126 |
| 3874 | 3003874475816 | 2126 |
| 3875 | 3003875991713 | 2126 |
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;