kapitel

17 rows where hörspielID = 147

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1278 147 147 1  
1279 147 147 2  
1280 147 147 3  
1281 147 147 4  
1282 147 147 5  
1283 147 147 6  
1284 147 147 7  
1285 147 147 8  
1286 147 147 9  
1287 147 147 10  
1288 147 147 11  
1289 147 147 12  
1290 147 147 13  
1291 147 147 14  
1292 147 147 15  
1293 147 147 16  
1294 147 147 17  

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