spricht

7 rows where personID = 498

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1672,498 1672 1672 Olaf Kreutzenbeck 498   1
1940,498 1940 1940 Olaf Kreutzenbeck 498   1
1981,498 1981 1981 Olaf Kreutzenbeck 498   1
2369,498 2369 2369 Olaf Kreutzenbeck 498   1
4995,498 4995 4995 Olaf Kreutzenbeck 498   1
4996,498 4996 4996 Olaf Kreutzenbeck 498   1
4997,498 4997 4997 Olaf Kreutzenbeck 498   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")
);