kapitel

24 rows where hörspielID = 406

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
3732 406 406 1  
3733 406 406 2  
3734 406 406 3  
3735 406 406 4  
3736 406 406 5  
3737 406 406 6  
3738 406 406 7  
3739 406 406 8  
3740 406 406 9  
3741 406 406 10  
3742 406 406 11  
3743 406 406 12  
3744 406 406 13  
3745 406 406 14  
3746 406 406 15  
3747 406 406 16  
3748 406 406 17  
3749 406 406 18  
3750 406 406 19  
3751 406 406 20  
3752 406 406 21  
3753 406 406 22  
3754 406 406 23  
3755 406 406 24  

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