kapitel

14 rows where hörspielID = 29

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
225 29 29 1  
226 29 29 2  
227 29 29 3  
228 29 29 4  
229 29 29 5  
230 29 29 6  
231 29 29 7  
232 29 29 8  
233 29 29 9  
234 29 29 10  
235 29 29 11  
236 29 29 12  
237 29 29 13  
238 29 29 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")
);