kapitel

14 rows where hörspielID = 122

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
963 122 122 1  
964 122 122 2  
965 122 122 3  
966 122 122 4  
967 122 122 5  
968 122 122 6  
969 122 122 7  
970 122 122 8  
971 122 122 9  
972 122 122 10  
973 122 122 11  
974 122 122 12  
975 122 122 13  
976 122 122 14  

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