kapitel

11 rows where hörspielID = 132

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1114 132 132 1  
1115 132 132 2  
1116 132 132 3  
1117 132 132 4  
1118 132 132 5  
1119 132 132 6  
1120 132 132 7  
1121 132 132 8  
1122 132 132 9  
1123 132 132 10  
1124 132 132 11  

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