spricht

6 rows where personID = 818

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
3138,818 3138 3138 Andreas Birnbaum 818   1
3149,818 3149 3149 Andreas Birnbaum 818   1
3415,818 3415 3415 Andreas Birnbaum 818   1
3438,818 3438 3438 Andreas Birnbaum 818   1
3451,818 3451 3451 Andreas Birnbaum 818   1
3623,818 3623 3623 Andreas Birnbaum 818   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")
);