kapitel

15 rows where hörspielID = 209

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1957 209 209 1  
1958 209 209 2  
1959 209 209 3  
1960 209 209 4  
1961 209 209 5  
1962 209 209 6  
1963 209 209 7  
1964 209 209 8  
1965 209 209 9  
1966 209 209 10  
1967 209 209 11  
1968 209 209 12  
1969 209 209 13  
1970 209 209 14  
1971 209 209 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")
);