kapitel

14 rows where hörspielID = 175

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1677 175 175 1  
1678 175 175 2  
1679 175 175 3  
1680 175 175 4  
1681 175 175 5  
1682 175 175 6  
1683 175 175 7  
1684 175 175 8  
1685 175 175 9  
1686 175 175 10  
1687 175 175 11  
1688 175 175 12  
1689 175 175 13  
1690 175 175 14  

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