spricht

6 rows where personID = 1112

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
4552,1112 4552 4552 Jana Kozewa 1112   1
4821,1112 4821 4821 Jana Kozewa 1112   1
4873,1112 4873 4873 Jana Kozewa 1112   1
4903,1112 4903 4903 Jana Kozewa 1112   1
4914,1112 4914 4914 Jana Kozewa 1112   1
4926,1112 4926 4926 Jana Kozewa 1112   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")
);