home / db

sprechrolleTeil

19 rows where hörspielID = 177

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID hörspielID position
2156,177 2156 2156 177 177 1
2157,177 2157 2157 177 177 2
2158,177 2158 2158 177 177 3
2159,177 2159 2159 177 177 4
2160,177 2160 2160 177 177 6
2163,177 2163 2163 177 177 10
2164,177 2164 2164 177 177 11
2166,177 2166 2166 177 177 13
2168,177 2168 2168 177 177 7
2170,177 2170 2170 177 177 14
2174,177 2174 2174 177 177 5
2175,177 2175 2175 177 177 12
2176,177 2176 2176 177 177 8
2178,177 2178 2178 177 177 15
2184,177 2184 2184 177 177 9
2185,177 2185 2185 177 177 16
2186,177 2186 2186 177 177 17
2187,177 2187 2187 177 177 18
2188,177 2188 2188 177 177 19

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "sprechrolleTeil"(
  "sprechrolleID" INTEGER NOT NULL REFERENCES "sprechrolle"("sprechrolleID") ON DELETE CASCADE ON UPDATE CASCADE,
  "hörspielID" INTEGER NOT NULL REFERENCES "hörspielTeil"("teil") ON DELETE CASCADE ON UPDATE CASCADE,
  "position" INTEGER NOT NULL CHECK("position" > 0),
  PRIMARY KEY("sprechrolleID", "hörspielID"),
  UNIQUE("hörspielID", "position")
);
Powered by Datasette · Queries took 5.745ms