spricht

9 rows where personID = 96

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
387,96 387 387 Sascha Draeger 96   1
518,96 518 518 Sascha Draeger 96   1
581,96 581 581 Sascha Draeger 96   1
1958,96 1958 1958 Sascha Draeger 96   1
2003,96 2003 2003 Sascha Draeger 96   1
2344,96 2344 2344 Sascha Draeger 96 Martin Sichel 63 1
2498,96 2498 2498 Sascha Draeger 96   1
2535,96 2535 2535 Sascha Draeger 96   1
3688,96 3688 3688 Sascha Draeger 96   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")
);