spricht

7 rows where personID = 218

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
789,218 789 789 Tilman Madaus 218   1
852,218 852 852 Tilman Madaus 218   1
1211,218 1211 1211 Tilman Madaus 218   1
1568,218 1568 1568 Tilman Madaus 218   1
1903,218 1903 1903 Tilman Madaus 218   1
2589,218 2589 2589 Tilman Madaus 218   1
3002,218 3002 3002 Tilman Madaus 218   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")
);