kapitel

15 rows where hörspielID = 118

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
915 118 118 1  
916 118 118 2  
917 118 118 3  
918 118 118 4  
919 118 118 5  
920 118 118 6  
921 118 118 7  
922 118 118 8  
923 118 118 9  
924 118 118 10  
925 118 118 11  
926 118 118 12  
927 118 118 13  
928 118 118 14  
929 118 118 15  

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