kapitel

12 rows where hörspielID = 167

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1520 167 167 1  
1521 167 167 2  
1522 167 167 3  
1523 167 167 4  
1524 167 167 5  
1525 167 167 6  
1526 167 167 7  
1527 167 167 8  
1528 167 167 9  
1529 167 167 10  
1530 167 167 11  
1531 167 167 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")
);