spricht

9 rows where personID = 313

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1061,313 1061 1061 Gustav-Adolph Artz 313 Igmar Frenzen 56 1
1398,313 1398 1398 Gustav-Adolph Artz 313   1
1605,313 1605 1605 Gustav-Adolph Artz 313   1
1846,313 1846 1846 Gustav-Adolph Artz 313   1
1910,313 1910 1910 Gustav-Adolph Artz 313   1
1923,313 1923 1923 Gustav-Adolph Artz 313   1
2252,313 2252 2252 Gustav-Adolph Artz 313   1
2426,313 2426 2426 Gustav-Adolph Artz 313   1
4021,313 4021 4021 Gustav-Adolph Artz 313   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")
);