spricht

7 rows where personID = 312

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1060,312 1060 1060 Gerhart Hinze 312   1
1319,312 1319 1319 Gerhart Hinze 312   1
1679,312 1679 1679 Gerhart Hinze 312   1
1839,312 1839 1839 Gerhart Hinze 312   1
1856,312 1856 1856 Gerhart Hinze 312   1
2300,312 2300 2300 Gerhart Hinze 312   1
2384,312 2384 2384 Gerhart Hinze 312   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")
);