kapitel

10 rows where hörspielID = 134

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1135 134 134 1  
1136 134 134 2  
1137 134 134 3  
1138 134 134 4  
1139 134 134 5  
1140 134 134 6  
1141 134 134 7  
1142 134 134 8  
1143 134 134 9  
1144 134 134 10  

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