kapitel

14 rows where hörspielID = 173

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1663 173 173 1  
1664 173 173 2  
1665 173 173 3  
1666 173 173 4  
1667 173 173 5  
1668 173 173 6  
1669 173 173 7  
1670 173 173 8  
1671 173 173 9  
1672 173 173 10  
1673 173 173 11  
1674 173 173 12  
1675 173 173 13  
1676 173 173 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")
);