spricht

13 rows where personID = 34

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
62,34 62 62 Joachim Wolff 34   1
75,34 75 75 Joachim Wolff 34   1
118,34 118 118 Joachim Wolff 34   1
132,34 132 132 Joachim Wolff 34 Ali Branowitch 19 1
176,34 176 176 Joachim Wolff 34   1
188,34 188 188 Joachim Wolff 34   1
205,34 205 205 Joachim Wolff 34   1
235,34 235 235 Joachim Wolff 34   1
301,34 301 301 Joachim Wolff 34 Erich Büttner 29 1
316,34 316 316 Joachim Wolff 34 Fritz Wegely 32 1
332,34 332 332 Joachim Wolff 34   1
417,34 417 417 Joachim Wolff 34   1
428,34 428 428 Joachim Wolff 34 Martin Fichte 42 1

Advanced export

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

CSV options: 

CREATE TABLE "spricht"(
  "sprechrolleID" INTEGER NOT NULL REFERENCES "sprechrolle"("sprechrolleID") ON DELETE CASCADE ON UPDATE CASCADE,
  "personID" INTEGER NOT NULL REFERENCES "person"("personID") ON DELETE CASCADE ON UPDATE CASCADE,
  "pseudonymID" INTEGER REFERENCES "pseudonym"("pseudonymID") ON DELETE SET NULL ON UPDATE CASCADE,
  "position" INTEGER NOT NULL CHECK("position" > 0),
  PRIMARY KEY("sprechrolleID", "personID"),
  UNIQUE("sprechrolleID", "position")
);