Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,251–5,275 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5251 | 3005251718287 | 2899 |
| 5252 | 3005252642542 | 2900 |
| 5253 | 3005253792738 | 2901 |
| 5254 | 3005254159277 | 2901 |
| 5255 | 3005255497162 | 2902 |
| 5256 | 3005256030794 | 2902 |
| 5257 | 3005257860531 | 2904 |
| 5258 | 3005258574625 | 2904 |
| 5259 | 3005259806373 | 2905 |
| 5260 | 3005260847848 | 2905 |
| 5261 | 3005261981084 | 2906 |
| 5262 | 3005262626373 | 2909 |
| 5263 | 3005263608262 | 2909 |
| 5264 | 3005264764928 | 2909 |
| 5265 | 3005265197342 | 2909 |
| 5266 | 3005266548217 | 2910 |
| 5267 | 3005267048943 | 2911 |
| 5268 | 3005268667026 | 2912 |
| 5269 | 3005269270751 | 2912 |
| 5270 | 3005270370679 | 2913 |
| 5271 | 3005271362669 | 2913 |
| 5272 | 3005272103703 | 2913 |
| 5273 | 3005273765854 | 2916 |
| 5274 | 3005274611083 | 2916 |
| 5275 | 3005275310790 | 2917 |
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;