track
8 rows where mediumID = 75
This data as json, CSV (advanced)
| trackID ▼ | mediumID | position | titel | dauer |
|---|---|---|---|---|
| 599 | 75 75 | 1 | Atemlos | 382227 |
| 600 | 75 75 | 2 | Ein Vogel auf dem Drahtseil | 425360 |
| 601 | 75 75 | 3 | Bodyguard | 549040 |
| 602 | 75 75 | 4 | Beethoven | 335333 |
| 603 | 75 75 | 5 | Auf der Flucht | 421267 |
| 604 | 75 75 | 6 | Menschen im Hotel | 438826 |
| 605 | 75 75 | 7 | Fame | 468200 |
| 606 | 75 75 | 8 | Die glorreichen Drei | 319347 |
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")
);