kapitel

12 rows where hörspielID = 141

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1201 141 141 1  
1202 141 141 2  
1203 141 141 3  
1204 141 141 4  
1205 141 141 5  
1206 141 141 6  
1207 141 141 7  
1208 141 141 8  
1209 141 141 9  
1210 141 141 10  
1211 141 141 11  
1212 141 141 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")
);