kapitel

11 rows where hörspielID = 204

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1892 204 204 1  
1893 204 204 2  
1894 204 204 3  
1895 204 204 4  
1896 204 204 5  
1897 204 204 6  
1898 204 204 7  
1899 204 204 8  
1900 204 204 9  
1901 204 204 10  
1902 204 204 11  

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