spricht

11 rows where personID = 76

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
230,76 230 230 Heidi Schaffrath 76   1
277,76 277 277 Heidi Schaffrath 76   1
478,76 478 478 Heidi Schaffrath 76   1
1248,76 1248 1248 Heidi Schaffrath 76   1
1418,76 1418 1418 Heidi Schaffrath 76   1
2363,76 2363 2363 Heidi Schaffrath 76   1
2511,76 2511 2511 Heidi Schaffrath 76   1
2677,76 2677 2677 Heidi Schaffrath 76   1
3125,76 3125 3125 Heidi Schaffrath 76   1
3291,76 3291 3291 Heidi Schaffrath 76   1
3632,76 3632 3632 Heidi Schaffrath 76   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")
);