spricht

10 rows where personID = 77

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
238,77 238 238 Joachim Richert 77   1
258,77 258 258 Joachim Richert 77   1
283,77 283 283 Joachim Richert 77   1
394,77 394 394 Joachim Richert 77   1
403,77 403 403 Joachim Richert 77   1
410,77 410 410 Joachim Richert 77   1
418,77 418 418 Joachim Richert 77   1
432,77 432 432 Joachim Richert 77   1
493,77 493 493 Joachim Richert 77   1
1425,77 1425 1425 Joachim Richert 77   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")
);