kapitel

17 rows where hörspielID = 153

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1351 153 153 1  
1352 153 153 2  
1353 153 153 3  
1354 153 153 4  
1355 153 153 5  
1356 153 153 6  
1357 153 153 7  
1358 153 153 8  
1359 153 153 9  
1360 153 153 10  
1361 153 153 11  
1362 153 153 12  
1363 153 153 13  
1364 153 153 14  
1365 153 153 15  
1366 153 153 16  
1367 153 153 17  

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