kapitel

14 rows where hörspielID = 123

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
977 123 123 1  
978 123 123 2  
979 123 123 3  
980 123 123 4  
981 123 123 5  
982 123 123 6  
983 123 123 7  
984 123 123 8  
985 123 123 9  
986 123 123 10  
987 123 123 11  
988 123 123 12  
989 123 123 13  
990 123 123 14  

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