kapitel

12 rows where hörspielID = 157

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1407 157 157 1  
1408 157 157 2  
1409 157 157 3  
1410 157 157 4  
1411 157 157 5  
1412 157 157 6  
1413 157 157 7  
1414 157 157 8  
1415 157 157 9  
1416 157 157 10  
1417 157 157 11  
1418 157 157 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")
);