kapitel

24 rows where hörspielID = 206

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1913 206 206 1  
1914 206 206 2  
1915 206 206 3  
1916 206 206 4  
1917 206 206 5  
1918 206 206 6  
1919 206 206 7  
1920 206 206 8  
1921 206 206 9  
1922 206 206 10  
1923 206 206 11  
1924 206 206 12  
1925 206 206 13  
1926 206 206 14  
1927 206 206 15  
1928 206 206 16  
1929 206 206 17  
1930 206 206 18  
1931 206 206 19  
1932 206 206 20  
1933 206 206 21  
1934 206 206 22  
1935 206 206 23  
1936 206 206 24  

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