spricht

8 rows where personID = 130

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
540,130 540 540 Beate Hasenau 130   1
554,130 554 554 Beate Hasenau 130   1
566,130 566 566 Beate Hasenau 130   1
809,130 809 809 Beate Hasenau 130   1
992,130 992 992 Beate Hasenau 130   1
1003,130 1003 1003 Beate Hasenau 130   1
1154,130 1154 1154 Beate Hasenau 130   1
1164,130 1164 1164 Beate Hasenau 130   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")
);