home / db

kapitel

26 rows where hörspielID = 125

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1002 125 125 1  
1003 125 125 2  
1004 125 125 3  
1005 125 125 4  
1006 125 125 5  
1007 125 125 6  
1008 125 125 7  
1009 125 125 8  
1010 125 125 9  
1011 125 125 10  
1012 125 125 11  
1013 125 125 12  
1014 125 125 13  
1015 125 125 14  
1016 125 125 15  
1017 125 125 16  
1018 125 125 17  
1019 125 125 18  
1020 125 125 19  
1021 125 125 20  
1022 125 125 21  
1023 125 125 22  
1024 125 125 23  
1025 125 125 24  
1026 125 125 25  
1027 125 125 26  

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")
);
Powered by Datasette · Queries took 5.545ms