spricht

7 rows where personID = 586

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
2038,586 2038 2038 Jens Wendland 586   1
2051,586 2051 2051 Jens Wendland 586   1
3885,586 3885 3885 Jens Wendland 586   1
3960,586 3960 3960 Jens Wendland 586   1
3989,586 3989 3989 Jens Wendland 586   1
4077,586 4077 4077 Jens Wendland 586   1
4117,586 4117 4117 Jens Wendland 586   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")
);