spricht

10 rows where personID = 686

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
2520,686 2520 2520 Merete Brettschneider 686   1
2780,686 2780 2780 Merete Brettschneider 686   1
2920,686 2920 2920 Merete Brettschneider 686   1
2921,686 2921 2921 Merete Brettschneider 686   1
2995,686 2995 2995 Merete Brettschneider 686   1
3354,686 3354 3354 Merete Brettschneider 686   1
3400,686 3400 3400 Merete Brettschneider 686   1
3657,686 3657 3657 Merete Brettschneider 686   1
3723,686 3723 3723 Merete Brettschneider 686   1
3929,686 3929 3929 Merete Brettschneider 686   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")
);