kapitel

8 rows where hörspielID = 335

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
3080 335 335 1  
3081 335 335 2  
3082 335 335 3  
3083 335 335 4  
3084 335 335 5  
3085 335 335 6  
3086 335 335 7  
3087 335 335 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")
);