track

8 rows where mediumID = 374

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
3464 374 374 1 Verschnupft 624293
3465 374 374 2 Lindwurm 697334
3466 374 374 3 Dienobot 397293
3467 374 374 4 Moderne Zeiten 524267
3468 374 374 5 Sesam, öffne dich! 459480
3469 374 374 6 Cobra-Alarm 452786
3470 374 374 7 Volltreffer 484907
3471 374 374 8 Mausefalle 407120

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