track
8 rows where mediumID = 299
This data as json, CSV (advanced)
| trackID ▼ | mediumID | position | titel | dauer |
|---|---|---|---|---|
| 2748 | 299 299 | 1 | "Sie bringen mich um!" | 370493 |
| 2749 | 299 299 | 2 | Kein neuer Fall | 568094 |
| 2750 | 299 299 | 3 | Vogelkunde | 777906 |
| 2751 | 299 299 | 4 | "Cawing Crows" | 526427 |
| 2752 | 299 299 | 5 | Angriff | 712147 |
| 2753 | 299 299 | 6 | Abstraktes Denken | 649933 |
| 2754 | 299 299 | 7 | Jackpot | 634987 |
| 2755 | 299 299 | 8 | Der Krähenflüsterer | 521333 |
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")
);