kapitel

13 rows where hörspielID = 152

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1338 152 152 1  
1339 152 152 2  
1340 152 152 3  
1341 152 152 4  
1342 152 152 5  
1343 152 152 6  
1344 152 152 7  
1345 152 152 8  
1346 152 152 9  
1347 152 152 10  
1348 152 152 11  
1349 152 152 12  
1350 152 152 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")
);