Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 4,076–4,100 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 4076 | 3004076536552 | 2278 |
| 4077 | 3004077917466 | 2278 |
| 4078 | 3004078510364 | 2278 |
| 4079 | 3004079771652 | 2281 |
| 4080 | 3004080698855 | 2281 |
| 4081 | 3004081376610 | 2282 |
| 4082 | 3004082905833 | 2282 |
| 4083 | 3004083183407 | 2283 |
| 4084 | 3004084632788 | 2283 |
| 4085 | 3004085625694 | 2284 |
| 4086 | 3004086136009 | 2284 |
| 4087 | 3004087816908 | 2288 |
| 4088 | 3004088051180 | 2288 |
| 4089 | 3004089954627 | 2289 |
| 4090 | 3004090410465 | 2289 |
| 4091 | 3004091029437 | 2290 |
| 4092 | 3004092198932 | 2290 |
| 4093 | 3004093938327 | 2292 |
| 4094 | 3004094152258 | 2292 |
| 4095 | 3004095758532 | 2292 |
| 4096 | 3004096921956 | 2294 |
| 4097 | 3004097254019 | 2294 |
| 4098 | 3004098417643 | 2295 |
| 4099 | 3004099076977 | 2296 |
| 4100 | 3004100353529 | 2296 |
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;