spricht

9 rows where personID = 22

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
25,22 25 25 Reiner Brönneke 22   1
45,22 45 45 Reiner Brönneke 22   1
82,22 82 82 Reiner Brönneke 22   1
92,22 92 92 Reiner Brönneke 22   1
107,22 107 107 Reiner Brönneke 22   1
135,22 135 135 Reiner Brönneke 22   1
294,22 294 294 Reiner Brönneke 22   1
330,22 330 330 Reiner Brönneke 22 Hans Meinhardt 5 1
646,22 646 646 Reiner Brönneke 22   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")
);