track

6 rows where mediumID = 265

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ mediumID position titel dauer
2485 265 265 1 "Hüte dich vor dem Mottenmann!" 562933
2486 265 265 2 Kwakwaka'wakw oder Nuu-cha-nulth? 609334
2487 265 265 3 Brennender Puppenwagen 425493
2488 265 265 4 Laothoe populi und andere Spuren 713347
2489 265 265 5 Das große Vergessen 909293
2490 265 265 6 Heilig 542467

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