kapitel

13 rows where hörspielID = 121

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
950 121 121 1  
951 121 121 2  
952 121 121 3  
953 121 121 4  
954 121 121 5  
955 121 121 6  
956 121 121 7  
957 121 121 8  
958 121 121 9  
959 121 121 10  
960 121 121 11  
961 121 121 12  
962 121 121 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")
);