spricht

7 rows where personID = 154

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
607,154 607 607 Gabriele Libbach 154   1
2188,154 2188 2188 Gabriele Libbach 154   1
2228,154 2228 2228 Gabriele Libbach 154   1
2338,154 2338 2338 Gabriele Libbach 154   1
2540,154 2540 2540 Gabriele Libbach 154   1
3303,154 3303 3303 Gabriele Libbach 154   1
3417,154 3417 3417 Gabriele Libbach 154   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")
);