kapitel

12 rows where hörspielID = 168

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1532 168 168 1  
1533 168 168 2  
1534 168 168 3  
1535 168 168 4  
1536 168 168 5  
1537 168 168 6  
1538 168 168 7  
1539 168 168 8  
1540 168 168 9  
1541 168 168 10  
1542 168 168 11  
1543 168 168 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")
);