kapitel

13 rows where hörspielID = 159

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1430 159 159 1  
1431 159 159 2  
1432 159 159 3  
1433 159 159 4  
1434 159 159 5  
1435 159 159 6  
1436 159 159 7  
1437 159 159 8  
1438 159 159 9  
1439 159 159 10  
1440 159 159 11  
1441 159 159 12  
1442 159 159 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")
);