track
10 rows where mediumID = 309
This data as json, CSV (advanced)
| trackID ▼ | mediumID | position | titel | dauer |
|---|---|---|---|---|
| 2923 | 309 309 | 1 | Tiefflieger | 336453 |
| 2924 | 309 309 | 2 | Aufräumarbeiten | 460014 |
| 2925 | 309 309 | 3 | Big Mama | 411613 |
| 2926 | 309 309 | 4 | Startklar | 337893 |
| 2927 | 309 309 | 5 | Sabotage | 344040 |
| 2928 | 309 309 | 6 | Spurensuche | 505280 |
| 2929 | 309 309 | 7 | Verdachtsmomente | 637814 |
| 2930 | 309 309 | 8 | Abgeführt | 577253 |
| 2931 | 309 309 | 9 | Neustart | 489960 |
| 2932 | 309 309 | 10 | SOS über den Wolken | 667027 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "track"(
"trackID" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"mediumID" INTEGER NOT NULL REFERENCES "medium"("mediumID") ON DELETE CASCADE ON UPDATE CASCADE,
"position" INTEGER NOT NULL CHECK("position" > 0),
"titel" TEXT NOT NULL,
"dauer" INTEGER NOT NULL CHECK("dauer" > 0),
UNIQUE("mediumID", "position")
);