spricht

11 rows where personID = 985

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
4051,985 4051 4051 Tobias Brecklinghaus 985   1
4061,985 4061 4061 Tobias Brecklinghaus 985   1
4090,985 4090 4090 Tobias Brecklinghaus 985   1
4102,985 4102 4102 Tobias Brecklinghaus 985   1
4210,985 4210 4210 Tobias Brecklinghaus 985   1
4220,985 4220 4220 Tobias Brecklinghaus 985   1
4302,985 4302 4302 Tobias Brecklinghaus 985   1
4807,985 4807 4807 Tobias Brecklinghaus 985   1
4872,985 4872 4872 Tobias Brecklinghaus 985   1
4892,985 4892 4892 Tobias Brecklinghaus 985   1
5135,985 5135 5135 Tobias Brecklinghaus 985   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")
);