kapitel

13 rows where hörspielID = 161

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1443 161 161 1  
1444 161 161 2  
1445 161 161 3  
1446 161 161 4  
1447 161 161 5  
1448 161 161 6  
1449 161 161 7  
1450 161 161 8  
1451 161 161 9  
1452 161 161 10  
1453 161 161 11  
1454 161 161 12  
1455 161 161 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")
);