spricht

8 rows where personID = 20

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
22,20 22 22 Peter Buchholz 20 Klaus-Peter Reisch 4 1
53,20 53 53 Peter Buchholz 20   1
64,20 64 64 Peter Buchholz 20   1
81,20 81 81 Peter Buchholz 20   1
108,20 108 108 Peter Buchholz 20   1
134,20 134 134 Peter Buchholz 20   1
2039,20 2039 2039 Peter Buchholz 20   1
3233,20 3233 3233 Peter Buchholz 20   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")
);