kapitel

13 rows where hörspielID = 115

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
876 115 115 1  
877 115 115 2  
878 115 115 3  
879 115 115 4  
880 115 115 5  
881 115 115 6  
882 115 115 7  
883 115 115 8  
884 115 115 9  
885 115 115 10  
886 115 115 11  
887 115 115 12  
888 115 115 13  

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