kapitel

13 rows where hörspielID = 136

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1153 136 136 1  
1154 136 136 2  
1155 136 136 3  
1156 136 136 4  
1157 136 136 5  
1158 136 136 6  
1159 136 136 7  
1160 136 136 8  
1161 136 136 9  
1162 136 136 10  
1163 136 136 11  
1164 136 136 12  
1165 136 136 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")
);