spricht

8 rows where personID = 264

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
942,264 942 942 Konstanze Ullmer 264   1
1861,264 1861 1861 Konstanze Ullmer 264   1
2147,264 2147 2147 Konstanze Ullmer 264   1
2180,264 2180 2180 Konstanze Ullmer 264   1
2293,264 2293 2293 Konstanze Ullmer 264   1
2368,264 2368 2368 Konstanze Ullmer 264   1
2517,264 2517 2517 Konstanze Ullmer 264   1
2581,264 2581 2581 Konstanze Ullmer 264   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")
);