spricht

9 rows where personID = 440

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1464,440 1464 1464 Peter Weis 440   1
1809,440 1809 1809 Peter Weis 440   1
2105,440 2105 2105 Peter Weis 440   1
2382,440 2382 2382 Peter Weis 440   1
2551,440 2551 2551 Peter Weis 440   1
2676,440 2676 2676 Peter Weis 440   1
3334,440 3334 3334 Peter Weis 440   1
3408,440 3408 3408 Peter Weis 440   1
3967,440 3967 3967 Peter Weis 440   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")
);