spricht

9 rows where personID = 121

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
502,121 502 502 Horst Naumann 121   1
517,121 517 517 Horst Naumann 121   1
534,121 534 534 Horst Naumann 121   1
548,121 548 548 Horst Naumann 121   1
580,121 580 580 Horst Naumann 121   1
1982,121 1982 1982 Horst Naumann 121   1
2418,121 2418 2418 Horst Naumann 121   1
2526,121 2526 2526 Horst Naumann 121   1
3052,121 3052 3052 Horst Naumann 121   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")
);