Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 3,951–3,975 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 3951 | 3003951177112 | 2171 |
| 3952 | 3003952587057 | 2173 |
| 3953 | 3003953607720 | 2176 |
| 3954 | 3003954791804 | 2176 |
| 3955 | 3003955731473 | 2179 |
| 3956 | 3003956915637 | 2179 |
| 3957 | 3003957221775 | 2180 |
| 3958 | 3003958395323 | 2180 |
| 3959 | 3003959767701 | 2180 |
| 3960 | 3003960385962 | 2182 |
| 3961 | 3003961883952 | 2182 |
| 3962 | 3003962094009 | 2185 |
| 3963 | 3003963922065 | 2185 |
| 3964 | 3003964362703 | 2185 |
| 3965 | 3003965562564 | 2186 |
| 3966 | 3003966294844 | 2186 |
| 3967 | 3003967981357 | 2186 |
| 3968 | 3003968377736 | 2186 |
| 3969 | 3003969874486 | 2188 |
| 3970 | 3003970454757 | 2188 |
| 3971 | 3003971966970 | 2188 |
| 3972 | 3003972129739 | 2189 |
| 3973 | 3003973929191 | 2189 |
| 3974 | 3003974775236 | 2190 |
| 3975 | 3003975441856 | 2192 |
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;