kapitel

12 rows where hörspielID = 226

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
2064 226 226 1  
2065 226 226 2  
2066 226 226 3  
2067 226 226 4  
2068 226 226 5  
2069 226 226 6  
2070 226 226 7  
2071 226 226 8  
2072 226 226 9  
2073 226 226 10  
2074 226 226 11  
2075 226 226 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")
);