track
9 rows where mediumID = 378
This data as json, CSV (advanced)
| trackID ▼ | mediumID | position | titel | dauer |
|---|---|---|---|---|
| 3497 | 378 378 | 1 | Jubiläum: 20 Jahre! | 354733 |
| 3498 | 378 378 | 2 | Feueralarm | 459894 |
| 3499 | 378 378 | 3 | Brandforscher | 484320 |
| 3500 | 378 378 | 4 | Geisterstadt | 827986 |
| 3501 | 378 378 | 5 | Mono See | 447080 |
| 3502 | 378 378 | 6 | Minenarbeiter | 426947 |
| 3503 | 378 378 | 7 | Kellergeister | 410373 |
| 3504 | 378 378 | 8 | Schatzjäger | 337080 |
| 3505 | 378 378 | 9 | Goldregen | 393707 |
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")
);