track

7 rows where mediumID = 351

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
3272 351 351 1 Kirschernte 558693
3273 351 351 2 Tarzanflug 603534
3274 351 351 3 Sensationsreporter 532840
3275 351 351 4 Holzfäller 720080
3276 351 351 5 Höhenrettung 732986
3277 351 351 6 Erpresser 571187
3278 351 351 7 Schatzräuber 656227

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