Table
ticket
Each admission ticket and its unique barcode.
Replaces in 2020: Ticket
Rows 2,326–2,350 of 9,842
| ticket_idINTEGER | barcodeTEXT | order_id→ purchase_order.order_id |
|---|---|---|
| 2326 | 3002326369253 | 1277 |
| 2327 | 3002327423651 | 1278 |
| 2328 | 3002328957321 | 1279 |
| 2329 | 3002329850174 | 1279 |
| 2330 | 3002330450956 | 1281 |
| 2331 | 3002331318259 | 1281 |
| 2332 | 3002332795836 | 1281 |
| 2333 | 3002333368960 | 1281 |
| 2334 | 3002334667340 | 1283 |
| 2335 | 3002335293360 | 1283 |
| 2336 | 3002336519811 | 1285 |
| 2337 | 3002337648551 | 1285 |
| 2338 | 3002338838472 | 1286 |
| 2339 | 3002339717270 | 1287 |
| 2340 | 3002340376383 | 1288 |
| 2341 | 3002341415608 | 1288 |
| 2342 | 3002342420793 | 1289 |
| 2343 | 3002343352036 | 1289 |
| 2344 | 3002344575353 | 1291 |
| 2345 | 3002345666756 | 1291 |
| 2346 | 3002346627618 | 1293 |
| 2347 | 3002347650631 | 1293 |
| 2348 | 3002348496923 | 1293 |
| 2349 | 3002349501519 | 1293 |
| 2350 | 3002350140792 | 1293 |
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;