spricht

8 rows where personID = 813

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
3128,813 3128 3128 Detlef Tams 813   1
3171,813 3171 3171 Detlef Tams 813   1
3519,813 3519 3519 Detlef Tams 813   1
4059,813 4059 4059 Detlef Tams 813   1
4088,813 4088 4088 Detlef Tams 813   1
4211,813 4211 4211 Detlef Tams 813   1
4457,813 4457 4457 Detlef Tams 813   1
5144,813 5144 5144 Detlef Tams 813   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")
);