spricht

8 rows where personID = 531

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1806,531 1806 1806 Henrike Fehrs 531   1
2660,531 2660 2660 Henrike Fehrs 531   1
3223,531 3223 3223 Henrike Fehrs 531   1
3295,531 3295 3295 Henrike Fehrs 531   1
3317,531 3317 3317 Henrike Fehrs 531   1
3641,531 3641 3641 Henrike Fehrs 531   1
3676,531 3676 3676 Henrike Fehrs 531   1
5079,531 5079 5079 Henrike Fehrs 531   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")
);