track
9 rows where mediumID = 366
This data as json, CSV (advanced)
| trackID ▼ | mediumID | position | titel | dauer |
|---|---|---|---|---|
| 3393 | 366 366 | 1 | Angelausflug | 520040 |
| 3394 | 366 366 | 2 | Geheimnis im Meer | 532360 |
| 3395 | 366 366 | 3 | Technikpanne | 431853 |
| 3396 | 366 366 | 4 | Spezialeffekte | 484720 |
| 3397 | 366 366 | 5 | Sabotage | 497867 |
| 3398 | 366 366 | 6 | Familiengeheimnis | 573520 |
| 3399 | 366 366 | 7 | Sonderkommando | 444627 |
| 3400 | 366 366 | 8 | Operation Sandwurm | 562440 |
| 3401 | 366 366 | 9 | Flutwelle | 504106 |
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")
);