kapitel

13 rows where hörspielID = 166

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1507 166 166 1  
1508 166 166 2  
1509 166 166 3  
1510 166 166 4  
1511 166 166 5  
1512 166 166 6  
1513 166 166 7  
1514 166 166 8  
1515 166 166 9  
1516 166 166 10  
1517 166 166 11  
1518 166 166 12  
1519 166 166 13  

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