kapitel

18 rows where hörspielID = 303

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
2718 303 303 1  
2719 303 303 2  
2720 303 303 3  
2721 303 303 4  
2722 303 303 5  
2723 303 303 6  
2724 303 303 7  
2725 303 303 8  
2726 303 303 9  
2727 303 303 10  
2728 303 303 11  
2729 303 303 12  
2730 303 303 13  
2731 303 303 14  
2732 303 303 15  
2733 303 303 16  
2734 303 303 17  
2735 303 303 18  

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