spricht

11 rows where personID = 651

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
2288,651 2288 2288 Till Huster 651   1
2707,651 2707 2707 Till Huster 651   1
2789,651 2789 2789 Till Huster 651   1
2864,651 2864 2864 Till Huster 651   1
3029,651 3029 3029 Till Huster 651   1
3183,651 3183 3183 Till Huster 651   1
3277,651 3277 3277 Till Huster 651   1
3494,651 3494 3494 Till Huster 651   1
3702,651 3702 3702 Till Huster 651   1
5053,651 5053 5053 Till Huster 651   1
5177,651 5177 5177 Till Huster 651   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")
);