kapitel

13 rows where hörspielID = 127

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1040 127 127 1  
1041 127 127 2  
1042 127 127 3  
1043 127 127 4  
1044 127 127 5  
1045 127 127 6  
1046 127 127 7  
1047 127 127 8  
1048 127 127 9  
1049 127 127 10  
1050 127 127 11  
1051 127 127 12  
1052 127 127 13  

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