spricht

12 rows where personID = 259

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
937,259 937 937 Michael Lott 259   1
954,259 954 954 Michael Lott 259   1
1673,259 1673 1673 Michael Lott 259   1
2033,259 2033 2033 Michael Lott 259   1
2577,259 2577 2577 Michael Lott 259   1
3034,259 3034 3034 Michael Lott 259   1
3255,259 3255 3255 Michael Lott 259   1
3739,259 3739 3739 Michael Lott 259   1
4546,259 4546 4546 Michael Lott 259   1
4819,259 4819 4819 Michael Lott 259   1
4900,259 4900 4900 Michael Lott 259   1
4954,259 4954 4954 Michael Lott 259   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")
);