kapitel

12 rows where hörspielID = 146

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1266 146 146 1  
1267 146 146 2  
1268 146 146 3  
1269 146 146 4  
1270 146 146 5  
1271 146 146 6  
1272 146 146 7  
1273 146 146 8  
1274 146 146 9  
1275 146 146 10  
1276 146 146 11  
1277 146 146 12  

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