track

8 rows where mediumID = 195

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
1921 195 195 1 9. Dezember 418440
1922 195 195 2 10. Dezember 390387
1923 195 195 3 11. Dezember 472853
1924 195 195 4 12. Dezember 369040
1925 195 195 5 13. Dezember 407027
1926 195 195 6 14. Dezember 243253
1927 195 195 7 15. Dezember 375493
1928 195 195 8 16. Dezember 167254

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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")
);