spricht

6 rows where personID = 513

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1716,513 1716 1716 Holger Wemhoff 513   1
2763,513 2763 2763 Holger Wemhoff 513   1
2899,513 2899 2899 Holger Wemhoff 513   1
3476,513 3476 3476 Holger Wemhoff 513   1
3493,513 3493 3493 Holger Wemhoff 513   1
3624,513 3624 3624 Holger Wemhoff 513   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")
);