kapitel

12 rows where hörspielID = 126

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1028 126 126 1  
1029 126 126 2  
1030 126 126 3  
1031 126 126 4  
1032 126 126 5  
1033 126 126 6  
1034 126 126 7  
1035 126 126 8  
1036 126 126 9  
1037 126 126 10  
1038 126 126 11  
1039 126 126 12  

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