track

11 rows where mediumID = 179

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
1755 179 179 1 Konferenzschaltung 431987
1756 179 179 2 Pseudonyme 260786
1757 179 179 3 Schlechter Empfang 287054
1758 179 179 4 Genie-Streich 321173
1759 179 179 5 Neues Rätsel 176173
1760 179 179 6 Homepage 271547
1761 179 179 7 50.000 186267
1762 179 179 8 Störung 201840
1763 179 179 9 Schuss 335146
1764 179 179 10 Griechische Tragödie 386667
1765 179 179 11 Kalte Dusche 385320

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