spricht

7 rows where personID = 266

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
949,266 949 949 Sabine Hahn 266   1
1547,266 1547 1547 Sabine Hahn 266   1
1826,266 1826 1826 Sabine Hahn 266   1
1911,266 1911 1911 Sabine Hahn 266   1
2509,266 2509 2509 Sabine Hahn 266   1
3105,266 3105 3105 Sabine Hahn 266   1
3132,266 3132 3132 Sabine Hahn 266   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")
);