track

11 rows where mediumID = 124

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
991 124 124 1 Panik! 265680
992 124 124 2 Der Lebensretter 281907
993 124 124 3 Mehrere Todesopfer 369840
994 124 124 4 Im Tropeninstitut 571160
995 124 124 5 Deep Throat 274586
996 124 124 6 Feueralarm 393040
997 124 124 7 Von Gifttieren attackiert 232147
998 124 124 8 Notruf 440333
999 124 124 9 Die Lösung 166120
1000 124 124 10 Purer Sand 257174
1001 124 124 11 Einfache Logik 276266

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