kapitel

16 rows where hörspielID = 183

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1779 183 183 1  
1780 183 183 2  
1781 183 183 3  
1782 183 183 4  
1783 183 183 5  
1784 183 183 6  
1785 183 183 7  
1786 183 183 8  
1787 183 183 9  
1788 183 183 10  
1789 183 183 11  
1790 183 183 12  
1791 183 183 13  
1792 183 183 14  
1793 183 183 15  
1794 183 183 16  

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