kapitel

16 rows where hörspielID = 169

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1544 169 169 1  
1545 169 169 2  
1546 169 169 3  
1547 169 169 4  
1548 169 169 5  
1549 169 169 6  
1550 169 169 7  
1551 169 169 8  
1552 169 169 9  
1553 169 169 10  
1554 169 169 11  
1555 169 169 12  
1556 169 169 13  
1557 169 169 14  
1558 169 169 15  
1559 169 169 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")
);