kapitel

15 rows where hörspielID = 184

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1795 184 184 1  
1796 184 184 2  
1797 184 184 3  
1798 184 184 4  
1799 184 184 5  
1800 184 184 6  
1801 184 184 7  
1802 184 184 8  
1803 184 184 9  
1804 184 184 10  
1805 184 184 11  
1806 184 184 12  
1807 184 184 13  
1808 184 184 14  
1809 184 184 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")
);