spricht

7 rows where personID = 210

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
768,210 768 768 Hansi Jochmann 210   1
919,210 919 919 Hansi Jochmann 210   1
1109,210 1109 1109 Hansi Jochmann 210   1
1297,210 1297 1297 Hansi Jochmann 210   1
1978,210 1978 1978 Hansi Jochmann 210   1
2939,210 2939 2939 Hansi Jochmann 210   1
3033,210 3033 3033 Hansi Jochmann 210   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")
);