kapitel

15 rows where hörspielID = 139

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1186 139 139 1  
1187 139 139 2  
1188 139 139 3  
1189 139 139 4  
1190 139 139 5  
1191 139 139 6  
1192 139 139 7  
1193 139 139 8  
1194 139 139 9  
1195 139 139 10  
1196 139 139 11  
1197 139 139 12  
1198 139 139 13  
1199 139 139 14  
1200 139 139 15  

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