spricht

7 rows where personID = 976

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: position

Link sprechrolleID personID pseudonymID position
4011,976 4011 4011 Ansgar Döbertin 976   1
4267,976 4267 4267 Ansgar Döbertin 976   1
4440,976 4440 4440 Ansgar Döbertin 976   1
4645,976 4645 4645 Ansgar Döbertin 976   1
4706,976 4706 4706 Ansgar Döbertin 976   1
4750,976 4750 4750 Ansgar Döbertin 976   2
4837,976 4837 4837 Ansgar Döbertin 976   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")
);