kapitel

13 rows where hörspielID = 156

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1394 156 156 1  
1395 156 156 2  
1396 156 156 3  
1397 156 156 4  
1398 156 156 5  
1399 156 156 6  
1400 156 156 7  
1401 156 156 8  
1402 156 156 9  
1403 156 156 10  
1404 156 156 11  
1405 156 156 12  
1406 156 156 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")
);