spricht

12 rows where personID = 189

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
710,189 710 710 Henry König 189   1
723,189 723 723 Henry König 189   1
1528,189 1528 1528 Henry König 189   1
1972,189 1972 1972 Henry König 189   1
2146,189 2146 2146 Henry König 189   1
2179,189 2179 2179 Henry König 189   1
2232,189 2232 2232 Henry König 189   1
2466,189 2466 2466 Henry König 189   1
2516,189 2516 2516 Henry König 189   1
2580,189 2580 2580 Henry König 189   1
2655,189 2655 2655 Henry König 189   1
3040,189 3040 3040 Henry König 189   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")
);