spricht

10 rows where personID = 487

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1641,487 1641 1641 Robin Brosch 487   1
1666,487 1666 1666 Robin Brosch 487   1
2049,487 2049 2049 Robin Brosch 487   1
2080,487 2080 2080 Robin Brosch 487   1
2383,487 2383 2383 Robin Brosch 487   1
2460,487 2460 2460 Robin Brosch 487   1
2585,487 2585 2585 Robin Brosch 487   1
3003,487 3003 3003 Robin Brosch 487   1
3375,487 3375 3375 Robin Brosch 487   1
3659,487 3659 3659 Robin Brosch 487   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")
);