track

10 rows where mediumID = 133

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
1125 133 133 1 Gewonnen! 231600
1126 133 133 2 Attentat 659973
1127 133 133 3 Kreidebleich 143934
1128 133 133 4 Spiegel der Seele 526040
1129 133 133 5 Attacke 173493
1130 133 133 6 Vollgas 704560
1131 133 133 7 Gage 134120
1132 133 133 8 Überwacht 157333
1133 133 133 9 Verhaftet 209974
1134 133 133 10 Endspiel 983733

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