spricht

7 rows where personID = 51

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
142,51 142 142 Wolf Rahtjen 51   1
182,51 182 182 Wolf Rahtjen 51   1
585,51 585 585 Wolf Rahtjen 51 Peter Pantel 45 1
657,51 657 657 Wolf Rahtjen 51   1
1187,51 1187 1187 Wolf Rahtjen 51   1
1376,51 1376 1376 Wolf Rahtjen 51   1
1403,51 1403 1403 Wolf Rahtjen 51   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")
);