spricht

14 rows where personID = 11

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
9,11 9 9 Stefan Brönneke 11   1
49,11 49 49 Stefan Brönneke 11 Philip Baader 11 1
295,11 295 295 Stefan Brönneke 11   1
587,11 587 587 Stefan Brönneke 11   1
690,11 690 690 Stefan Brönneke 11   1
735,11 735 735 Stefan Brönneke 11   1
1498,11 1498 1498 Stefan Brönneke 11   1
1514,11 1514 1514 Stefan Brönneke 11   1
1651,11 1651 1651 Stefan Brönneke 11   1
2048,11 2048 2048 Stefan Brönneke 11   1
2532,11 2532 2532 Stefan Brönneke 11   1
2837,11 2837 2837 Stefan Brönneke 11   1
3280,11 3280 3280 Stefan Brönneke 11   1
3662,11 3662 3662 Stefan Brönneke 11   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")
);