kapitel

8 rows where hörspielID = 98

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
747 98 98 1  
748 98 98 2  
749 98 98 3  
750 98 98 4  
751 98 98 5  
752 98 98 6  
753 98 98 7  
754 98 98 8  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "kapitel"(
  "trackID" INTEGER PRIMARY KEY NOT NULL REFERENCES "track"("trackID") ON DELETE CASCADE ON UPDATE CASCADE,
  "hörspielID" INTEGER NOT NULL REFERENCES "hörspiel"("hörspielID") ON DELETE CASCADE ON UPDATE CASCADE,
  "position" INTEGER NOT NULL CHECK("position" > 0),
  "abweichenderTitel" TEXT,
  UNIQUE("hörspielID", "position")
);