kapitel

16 rows where hörspielID = 176

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1691 176 176 1  
1692 176 176 2  
1693 176 176 3  
1694 176 176 4  
1695 176 176 5  
1696 176 176 6  
1697 176 176 7  
1698 176 176 8  
1699 176 176 9  
1700 176 176 10  
1701 176 176 11  
1702 176 176 12  
1703 176 176 13  
1704 176 176 14  
1705 176 176 15  
1706 176 176 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")
);