spricht

14 rows where personID = 247

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
894,247 894 894 Nicolas König 247   1
1045,247 1045 1045 Nicolas König 247   1
1286,247 1286 1286 Nicolas König 247   1
1593,247 1593 1593 Nicolas König 247   1
1851,247 1851 1851 Nicolas König 247   1
2053,247 2053 2053 Nicolas König 247   1
2561,247 2561 2561 Nicolas König 247   1
2719,247 2719 2719 Nicolas König 247   1
2730,247 2730 2730 Nicolas König 247   1
2777,247 2777 2777 Nicolas König 247   1
3471,247 3471 3471 Nicolas König 247   1
3646,247 3646 3646 Nicolas König 247   1
3747,247 3747 3747 Nicolas König 247   1
3932,247 3932 3932 Nicolas König 247   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")
);