kapitel

11 rows where hörspielID = 203

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1881 203 203 1  
1882 203 203 2  
1883 203 203 3  
1884 203 203 4  
1885 203 203 5  
1886 203 203 6  
1887 203 203 7  
1888 203 203 8  
1889 203 203 9  
1890 203 203 10  
1891 203 203 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")
);