kapitel

24 rows where hörspielID = 244

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
2180 244 244 1  
2181 244 244 2  
2182 244 244 3  
2183 244 244 4  
2184 244 244 5  
2185 244 244 6  
2186 244 244 7  
2187 244 244 8  
2188 244 244 9  
2189 244 244 10  
2190 244 244 11  
2191 244 244 12  
2192 244 244 13  
2193 244 244 14  
2194 244 244 15  
2195 244 244 16  
2196 244 244 17  
2197 244 244 18  
2198 244 244 19  
2199 244 244 20  
2200 244 244 21  
2201 244 244 22  
2202 244 244 23  
2203 244 244 24  

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