spricht

6 rows where personID = 635

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
2213,635 2213 2213 Stephan Schwartz 635   1
2390,635 2390 2390 Stephan Schwartz 635   1
2597,635 2597 2597 Stephan Schwartz 635   1
2987,635 2987 2987 Stephan Schwartz 635   1
3966,635 3966 3966 Stephan Schwartz 635   1
5034,635 5034 5034 Stephan Schwartz 635   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")
);