spricht

14 rows where personID = 471

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1580,471 1580 1580 Patrick Bach 471   1
1594,471 1594 1594 Patrick Bach 471   1
1704,471 1704 1704 Patrick Bach 471   1
1737,471 1737 1737 Patrick Bach 471   1
1748,471 1748 1748 Patrick Bach 471   1
1933,471 1933 1933 Patrick Bach 471   1
1970,471 1970 1970 Patrick Bach 471   1
2095,471 2095 2095 Patrick Bach 471   1
2123,471 2123 2123 Patrick Bach 471   1
2353,471 2353 2353 Patrick Bach 471   1
2528,471 2528 2528 Patrick Bach 471   1
2999,471 2999 2999 Patrick Bach 471   1
4152,471 4152 4152 Patrick Bach 471   1
5021,471 5021 5021 Patrick Bach 471   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")
);