kapitel

12 rows where hörspielID = 248

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
2227 248 248 1  
2228 248 248 2  
2229 248 248 3  
2230 248 248 4  
2231 248 248 5  
2232 248 248 6  
2233 248 248 7  
2234 248 248 8  
2235 248 248 9  
2236 248 248 10  
2237 248 248 11  
2238 248 248 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")
);