spricht

7 rows where personID = 127

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
528,127 528 528 Michael Grimm 127   1
2525,127 2525 2525 Michael Grimm 127   1
2847,127 2847 2847 Michael Grimm 127   1
3603,127 3603 3603 Michael Grimm 127   1
4196,127 4196 4196 Michael Grimm 127   1
4458,127 4458 4458 Michael Grimm 127   1
5019,127 5019 5019 Michael Grimm 127   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")
);