track
8 rows where mediumID = 62
This data as json, CSV (advanced)
| trackID ▼ | mediumID | position | titel | dauer |
|---|---|---|---|---|
| 495 | 62 62 | 1 | Knobeln mit Folgen | 297440 |
| 496 | 62 62 | 2 | Amandas "Old Star" | 573933 |
| 497 | 62 62 | 3 | Der Dieb schlägt wieder zu | 576934 |
| 498 | 62 62 | 4 | Amandas Geheimnis | 334413 |
| 499 | 62 62 | 5 | Geister und Ganoven | 594907 |
| 500 | 62 62 | 6 | Diebin in Aktion | 482080 |
| 501 | 62 62 | 7 | Feuer | 405906 |
| 502 | 62 62 | 8 | Zur Feier des Tages | 297614 |
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")
);