kapitel

13 rows where hörspielID = 199

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1834 199 199 1  
1835 199 199 2  
1836 199 199 3  
1837 199 199 4  
1838 199 199 5  
1839 199 199 6  
1840 199 199 7  
1841 199 199 8  
1842 199 199 9  
1843 199 199 10  
1844 199 199 11  
1845 199 199 12  
1846 199 199 13  

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