home / db

kapitel

25 rows where hörspielID = 129

✎ View and edit SQL

This data as json, CSV (advanced)

trackID ▼ hörspielID position abweichenderTitel
1053 129 129 1  
1054 129 129 2  
1055 129 129 3  
1056 129 129 4  
1057 129 129 5  
1058 129 129 6  
1059 129 129 7  
1060 129 129 8  
1061 129 129 9  
1062 129 129 10  
1063 129 129 11  
1064 129 129 12  
1065 129 129 13  
1066 129 129 14  
1067 129 129 15  
1068 129 129 16  
1069 129 129 17  
1070 129 129 18  
1071 129 129 19  
1072 129 129 20  
1073 129 129 21  
1074 129 129 22  
1075 129 129 23  
1076 129 129 24  
1077 129 129 25  

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 8.313ms