spricht

7 rows where personID = 626

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
2177,626 2177 2177 Angela Stresemann 626   1
2494,626 2494 2494 Angela Stresemann 626   1
2514,626 2514 2514 Angela Stresemann 626   1
2519,626 2519 2519 Angela Stresemann 626   1
3140,626 3140 3140 Angela Stresemann 626   1
3546,626 3546 3546 Angela Stresemann 626   1
3574,626 3574 3574 Angela Stresemann 626   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")
);