kapitel

13 rows where hörspielID = 164

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1483 164 164 1  
1484 164 164 2  
1485 164 164 3  
1486 164 164 4  
1487 164 164 5  
1488 164 164 6  
1489 164 164 7  
1490 164 164 8  
1491 164 164 9  
1492 164 164 10  
1493 164 164 11  
1494 164 164 12  
1495 164 164 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")
);