spricht

15 rows where personID = 63

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
184,63 184 184 Lutz Mackensy 63   1
342,63 342 342 Lutz Mackensy 63   1
504,63 504 504 Lutz Mackensy 63   1
675,63 675 675 Lutz Mackensy 63   1
1101,63 1101 1101 Lutz Mackensy 63   1
1255,63 1255 1255 Lutz Mackensy 63   1
1587,63 1587 1587 Lutz Mackensy 63   1
2545,63 2545 2545 Lutz Mackensy 63   1
2638,63 2638 2638 Lutz Mackensy 63   1
3086,63 3086 3086 Lutz Mackensy 63   1
3150,63 3150 3150 Lutz Mackensy 63   1
3486,63 3486 3486 Lutz Mackensy 63   1
4277,63 4277 4277 Lutz Mackensy 63   1
4290,63 4290 4290 Lutz Mackensy 63   1
4683,63 4683 4683 Lutz Mackensy 63   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")
);