spricht

6 rows where personID = 93

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
346,93 346 346 Susanne Wulkow 93   1
461,93 461 461 Susanne Wulkow 93   1
1908,93 1908 1908 Susanne Wulkow 93   1
2060,93 2060 2060 Susanne Wulkow 93   1
2695,93 2695 2695 Susanne Wulkow 93   1
3087,93 3087 3087 Susanne Wulkow 93   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")
);