kapitel

12 rows where hörspielID = 422

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
3813 422 422 1  
3814 422 422 2  
3815 422 422 3  
3816 422 422 4  
3817 422 422 5  
3818 422 422 6  
3819 422 422 7  
3820 422 422 8  
3821 422 422 9  
3822 422 422 10  
3823 422 422 11  
3824 422 422 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")
);