home / db

sprechrolleTeil

19 rows where hörspielID = 176

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID hörspielID position
2156,176 2156 2156 176 176 1
2157,176 2157 2157 176 176 2
2158,176 2158 2158 176 176 3
2159,176 2159 2159 176 176 4
2160,176 2160 2160 176 176 16
2164,176 2164 2164 176 176 11
2167,176 2167 2167 176 176 10
2168,176 2168 2168 176 176 6
2170,176 2170 2170 176 176 12
2174,176 2174 2174 176 176 5
2175,176 2175 2175 176 176 7
2176,176 2176 2176 176 176 8
2177,176 2177 2177 176 176 9
2178,176 2178 2178 176 176 13
2179,176 2179 2179 176 176 14
2180,176 2180 2180 176 176 15
2181,176 2181 2181 176 176 17
2182,176 2182 2182 176 176 18
2183,176 2183 2183 176 176 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.178ms