kapitel

8 rows where hörspielID = 365

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
3320 365 365 1  
3321 365 365 2  
3322 365 365 3  
3323 365 365 4  
3324 365 365 5  
3325 365 365 6  
3326 365 365 7  
3327 365 365 8  

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