spricht

10 rows where personID = 610

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
2127,610 2127 2127 Tim Grobe 610   1
2150,610 2150 2150 Tim Grobe 610   1
2175,610 2175 2175 Tim Grobe 610   1
2662,610 2662 2662 Tim Grobe 610   1
2992,610 2992 2992 Tim Grobe 610   1
3315,610 3315 3315 Tim Grobe 610   1
3565,610 3565 3565 Tim Grobe 610   1
3693,610 3693 3693 Tim Grobe 610   1
3721,610 3721 3721 Tim Grobe 610   1
5051,610 5051 5051 Tim Grobe 610   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")
);