spricht

8 rows where personID = 836

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
3245,836 3245 3245 Till Hagen 836   1
3640,836 3640 3640 Till Hagen 836   1
3746,836 3746 3746 Till Hagen 836   1
4690,836 4690 4690 Till Hagen 836   1
4935,836 4935 4935 Till Hagen 836   1
5068,836 5068 5068 Till Hagen 836   1
5156,836 5156 5156 Till Hagen 836   1
5169,836 5169 5169 Till Hagen 836   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")
);