spricht

7 rows where personID = 599

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
2085,599 2085 2085 Santiago Ziesmer 599   1
2120,599 2120 2120 Santiago Ziesmer 599   1
2988,599 2988 2988 Santiago Ziesmer 599   1
2989,599 2989 2989 Santiago Ziesmer 599   1
3200,599 3200 3200 Santiago Ziesmer 599   1
4060,599 4060 4060 Santiago Ziesmer 599   1
5146,599 5146 5146 Santiago Ziesmer 599   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")
);