kapitel

24 rows where hörspielID = 412

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
3780 412 412 1  
3781 412 412 2  
3782 412 412 3  
3783 412 412 4  
3784 412 412 5  
3785 412 412 6  
3786 412 412 7  
3787 412 412 8  
3788 412 412 9  
3789 412 412 10  
3790 412 412 11  
3791 412 412 12  
3792 412 412 13  
3793 412 412 14  
3794 412 412 15  
3795 412 412 16  
3796 412 412 17  
3797 412 412 18  
3798 412 412 19  
3799 412 412 20  
3800 412 412 21  
3801 412 412 22  
3802 412 412 23  
3803 412 412 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")
);