Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 5,276–5,300 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 5276 | 3005276586307 | 2921 |
| 5277 | 3005277140803 | 2921 |
| 5278 | 3005278603539 | 2921 |
| 5279 | 3005279490645 | 2921 |
| 5280 | 3005280179118 | 2922 |
| 5281 | 3005281615996 | 2924 |
| 5282 | 3005282736782 | 2924 |
| 5283 | 3005283916586 | 2925 |
| 5284 | 3005284498744 | 2925 |
| 5285 | 3005285139081 | 2925 |
| 5286 | 3005286454072 | 2925 |
| 5287 | 3005287117288 | 2927 |
| 5288 | 3005288961637 | 2927 |
| 5289 | 3005289474139 | 2928 |
| 5290 | 3005290752720 | 2928 |
| 5291 | 3005291337388 | 2929 |
| 5292 | 3005292385122 | 2930 |
| 5293 | 3005293013390 | 2930 |
| 5294 | 3005294334953 | 2931 |
| 5295 | 3005295110762 | 2932 |
| 5296 | 3005296846228 | 2932 |
| 5297 | 3005297125722 | 2933 |
| 5298 | 3005298131129 | 2933 |
| 5299 | 3005299779564 | 2937 |
| 5300 | 3005300346996 | 2937 |
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;