track

7 rows where mediumID = 399

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
3680 399 399 1 Erpressung 600960
3681 399 399 2 Offensichtlich gelogen 538987
3682 399 399 3 Amnesie 370626
3683 399 399 4 Auf dem Radar 541560
3684 399 399 5 Chloroform 750520
3685 399 399 6 Her mit der Tasche! 1243054
3686 399 399 7 Zahlendreher 822573

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