spricht

11 rows where personID = 19

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
21,19 21 21 Fabian Harloff 19   1
704,19 704 704 Fabian Harloff 19   1
1257,19 1257 1257 Fabian Harloff 19 Jakob Lichtblau 58 1
1610,19 1610 1610 Fabian Harloff 19   1
1725,19 1725 1725 Fabian Harloff 19   1
1836,19 1836 1836 Fabian Harloff 19   1
2043,19 2043 2043 Fabian Harloff 19   1
2269,19 2269 2269 Fabian Harloff 19   1
2604,19 2604 2604 Fabian Harloff 19   1
3394,19 3394 3394 Fabian Harloff 19   1
5023,19 5023 5023 Fabian Harloff 19   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")
);