spricht

11 rows where personID = 110

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
456,110 456 456 Utz Richter 110   1
466,110 466 466 Utz Richter 110   1
593,110 593 593 Utz Richter 110   1
811,110 811 811 Utz Richter 110   1
881,110 881 881 Utz Richter 110   1
1222,110 1222 1222 Utz Richter 110   1
1563,110 1563 1563 Utz Richter 110   1
1729,110 1729 1729 Utz Richter 110   1
1779,110 1779 1779 Utz Richter 110   1
2233,110 2233 2233 Utz Richter 110   1
3858,110 3858 3858 Utz Richter 110   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")
);