track
12 rows where mediumID = 304
This data as json, CSV (advanced)
| trackID ▼ | mediumID | position | titel | dauer |
|---|---|---|---|---|
| 2868 | 304 304 | 1 | Schrotträtsel | 337160 |
| 2869 | 304 304 | 2 | Szenenwechsel | 273467 |
| 2870 | 304 304 | 3 | Filmsternchen | 273613 |
| 2871 | 304 304 | 4 | Feuer und Flamme | 397867 |
| 2872 | 304 304 | 5 | Heiße Spur | 335413 |
| 2873 | 304 304 | 6 | Nachtschatten | 437773 |
| 2874 | 304 304 | 7 | Hollywood | 257667 |
| 2875 | 304 304 | 8 | Kuchenpause | 316400 |
| 2876 | 304 304 | 9 | Sprungbereit | 365947 |
| 2877 | 304 304 | 10 | Am Abgrund | 344160 |
| 2878 | 304 304 | 11 | Showdown | 256080 |
| 2879 | 304 304 | 12 | Endeinstellung | 402093 |
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")
);