kapitel

12 rows where hörspielID = 180

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1743 180 180 1  
1744 180 180 2  
1745 180 180 3  
1746 180 180 4  
1747 180 180 5  
1748 180 180 6  
1749 180 180 7  
1750 180 180 8  
1751 180 180 9  
1752 180 180 10  
1753 180 180 11  
1754 180 180 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")
);