kapitel

13 rows where hörspielID = 155

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1381 155 155 1  
1382 155 155 2  
1383 155 155 3  
1384 155 155 4  
1385 155 155 5  
1386 155 155 6  
1387 155 155 7  
1388 155 155 8  
1389 155 155 9  
1390 155 155 10  
1391 155 155 11  
1392 155 155 12  
1393 155 155 13  

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