track

12 rows where mediumID = 166

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
1532 166 166 1 Band-Probe 240240
1533 166 166 2 Verschwunden 524347
1534 166 166 3 Zwischen den Stühlen 147093
1535 166 166 4 Depressionen? 263773
1536 166 166 5 Ausreißer 486054
1537 166 166 6 SynRea 151026
1538 166 166 7 Neue Energie 197800
1539 166 166 8 Elite-Einheiten 296814
1540 166 166 9 Ertappt 614226
1541 166 166 10 Der Meister 468800
1542 166 166 11 Am Ende des Weges 175440
1543 166 166 12 Alles vergessen 109840

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