spricht

7 rows where personID = 225

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
803,225 803 803 Ursula Sieg 225   1
813,225 813 813 Ursula Sieg 225   1
994,225 994 994 Ursula Sieg 225   1
2693,225 2693 2693 Ursula Sieg 225   1
3187,225 3187 3187 Ursula Sieg 225   1
3318,225 3318 3318 Ursula Sieg 225   1
5081,225 5081 5081 Ursula Sieg 225   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")
);