kapitel

16 rows where hörspielID = 148

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1295 148 148 1  
1296 148 148 2  
1297 148 148 3  
1298 148 148 4  
1299 148 148 5  
1300 148 148 6  
1301 148 148 7  
1302 148 148 8  
1303 148 148 9  
1304 148 148 10  
1305 148 148 11  
1306 148 148 12  
1307 148 148 13  
1308 148 148 14  
1309 148 148 15  
1310 148 148 16  

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