kapitel

24 rows where hörspielID = 427

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
3825 427 427 1  
3826 427 427 2  
3827 427 427 3  
3828 427 427 4  
3829 427 427 5  
3830 427 427 6  
3831 427 427 7  
3832 427 427 8  
3833 427 427 9  
3834 427 427 10  
3835 427 427 11  
3836 427 427 12  
3837 427 427 13  
3838 427 427 14  
3839 427 427 15  
3840 427 427 16  
3841 427 427 17  
3842 427 427 18  
3843 427 427 19  
3844 427 427 20  
3845 427 427 21  
3846 427 427 22  
3847 427 427 23  
3848 427 427 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")
);