track
10 rows where mediumID = 302
This data as json, CSV (advanced)
| trackID ▼ | mediumID | position | titel | dauer |
|---|---|---|---|---|
| 2845 | 302 302 | 1 | Hektik bei Titus | 359373 |
| 2846 | 302 302 | 2 | Spurensuche | 405520 |
| 2847 | 302 302 | 3 | Polizeiarbeit | 416814 |
| 2848 | 302 302 | 4 | Fred Fireman | 488680 |
| 2849 | 302 302 | 5 | Hinter Gittern | 381680 |
| 2850 | 302 302 | 6 | Radio Rocky Beach | 423880 |
| 2851 | 302 302 | 7 | Wunschhits | 322373 |
| 2852 | 302 302 | 8 | Auf der Lauer | 362480 |
| 2853 | 302 302 | 9 | Auf Sendung | 398733 |
| 2854 | 302 302 | 10 | Heimliche Helden | 467947 |
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")
);