Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 7,251–7,275 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 7251 | 3007251650478 | 3956 |
| 7252 | 3007252700977 | 3959 |
| 7253 | 3007253963902 | 3961 |
| 7254 | 3007254303725 | 3962 |
| 7255 | 3007255913680 | 3962 |
| 7256 | 3007256192106 | 3963 |
| 7257 | 3007257797855 | 3963 |
| 7258 | 3007258790083 | 3964 |
| 7259 | 3007259597573 | 3964 |
| 7260 | 3007260039357 | 3966 |
| 7261 | 3007261591869 | 3966 |
| 7262 | 3007262859980 | 3967 |
| 7263 | 3007263804388 | 3967 |
| 7264 | 3007264544076 | 3967 |
| 7265 | 3007265564402 | 3967 |
| 7266 | 3007266097013 | 3968 |
| 7267 | 3007267428852 | 3968 |
| 7268 | 3007268625709 | 3969 |
| 7269 | 3007269901980 | 3969 |
| 7270 | 3007270133557 | 3971 |
| 7271 | 3007271004843 | 3971 |
| 7272 | 3007272728352 | 3971 |
| 7273 | 3007273900983 | 3974 |
| 7274 | 3007274017813 | 3974 |
| 7275 | 3007275580093 | 3974 |
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;