spricht

15 rows where personID = 442

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: position

Link sprechrolleID personID pseudonymID position
1471,442 1471 1471 Stephan Benson 442   1
1803,442 1803 1803 Stephan Benson 442   1
2161,442 2161 2161 Stephan Benson 442   1
2391,442 2391 2391 Stephan Benson 442   1
2431,442 2431 2431 Stephan Benson 442   1
2530,442 2530 2530 Stephan Benson 442   1
2667,442 2667 2667 Stephan Benson 442   1
2964,442 2964 2964 Stephan Benson 442   19
2984,442 2984 2984 Stephan Benson 442   1
3188,442 3188 3188 Stephan Benson 442   1
3278,442 3278 3278 Stephan Benson 442   1
3296,442 3296 3296 Stephan Benson 442   1
3457,442 3457 3457 Stephan Benson 442   1
5004,442 5004 5004 Stephan Benson 442   1
5166,442 5166 5166 Stephan Benson 442   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")
);