kapitel

12 rows where hörspielID = 185

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1810 185 185 1  
1811 185 185 2  
1812 185 185 3  
1813 185 185 4  
1814 185 185 5  
1815 185 185 6  
1816 185 185 7  
1817 185 185 8  
1818 185 185 9  
1819 185 185 10  
1820 185 185 11  
1821 185 185 12  

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