spricht

7 rows where personID = 554

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1917,554 1917 1917 Christian Senger 554   1
1934,554 1934 1934 Christian Senger 554   1
1961,554 1961 1961 Christian Senger 554   1
2254,554 2254 2254 Christian Senger 554   1
2584,554 2584 2584 Christian Senger 554   1
2773,554 2773 2773 Christian Senger 554   1
4385,554 4385 4385 Christian Senger 554   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")
);