spricht

9 rows where personID = 177

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
673,177 673 673 Rainer Schmitt 177   1
708,177 708 708 Rainer Schmitt 177   1
1132,177 1132 1132 Rainer Schmitt 177   1
1629,177 1629 1629 Rainer Schmitt 177   1
1655,177 1655 1655 Rainer Schmitt 177   1
2237,177 2237 2237 Rainer Schmitt 177   1
2633,177 2633 2633 Rainer Schmitt 177   1
3439,177 3439 3439 Rainer Schmitt 177   1
5056,177 5056 5056 Rainer Schmitt 177   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")
);