kapitel

14 rows where hörspielID = 116

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
889 116 116 1  
890 116 116 2  
891 116 116 3  
892 116 116 4  
893 116 116 5  
894 116 116 6  
895 116 116 7  
896 116 116 8  
897 116 116 9  
898 116 116 10  
899 116 116 11  
900 116 116 12  
901 116 116 13  
902 116 116 14  

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