spricht

9 rows where personID = 157

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
611,157 611 611 Michael Quiatkowsky 157   1
644,157 644 644 Michael Quiatkowsky 157 Heiner Kramm 49 1
656,157 656 656 Michael Quiatkowsky 157   1
684,157 684 684 Michael Quiatkowsky 157   1
697,157 697 697 Michael Quiatkowsky 157   1
786,157 786 786 Michael Quiatkowsky 157   1
982,157 982 982 Michael Quiatkowsky 157   1
1125,157 1125 1125 Michael Quiatkowsky 157   1
1155,157 1155 1155 Michael Quiatkowsky 157   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")
);