spricht

7 rows where personID = 614

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
2133,614 2133 2133 Martin May 614   1
2212,614 2212 2212 Martin May 614   1
2851,614 2851 2851 Martin May 614   1
2883,614 2883 2883 Martin May 614   1
3445,614 3445 3445 Martin May 614   1
3633,614 3633 3633 Martin May 614   1
5020,614 5020 5020 Martin May 614   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")
);