track

7 rows where mediumID = 395

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
3654 395 395 1 Prayer's Hill 626000
3655 395 395 2 Der Tod im Garten 484307
3656 395 395 3 Día de los Muertos 540213
3657 395 395 4 R.I.P. 627453
3658 395 395 5 Blick in die Vergangenheit 789747
3659 395 395 6 2-058 488293
3660 395 395 7 Hände hoch! 653080

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