spricht

10 rows where personID = 250

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
909,250 909 909 Eberhard Haar 250   1
1180,250 1180 1180 Eberhard Haar 250   1
1579,250 1579 1579 Eberhard Haar 250   1
1718,250 1718 1718 Eberhard Haar 250   1
1833,250 1833 1833 Eberhard Haar 250   1
2022,250 2022 2022 Eberhard Haar 250   1
2425,250 2425 2425 Eberhard Haar 250   1
2917,250 2917 2917 Eberhard Haar 250   1
2996,250 2996 2996 Eberhard Haar 250   1
3896,250 3896 3896 Eberhard Haar 250   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")
);