kapitel

12 rows where hörspielID = 250

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
2248 250 250 1  
2249 250 250 2  
2250 250 250 3  
2251 250 250 4  
2252 250 250 5  
2253 250 250 6  
2254 250 250 7  
2255 250 250 8  
2256 250 250 9  
2257 250 250 10  
2258 250 250 11  
2259 250 250 12  

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