spricht

7 rows where personID = 391

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1326,391 1326 1326 Elga Schütz 391   1
1450,391 1450 1450 Elga Schütz 391   1
2485,391 2485 2485 Elga Schütz 391   1
2658,391 2658 2658 Elga Schütz 391   1
2769,391 2769 2769 Elga Schütz 391   1
3504,391 3504 3504 Elga Schütz 391   1
4223,391 4223 4223 Elga Schütz 391   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")
);