spricht

10 rows where personID = 36

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
66,36 66 66 Renate Pichler 36   1
106,36 106 106 Renate Pichler 36   1
154,36 154 154 Renate Pichler 36   1
426,36 426 426 Renate Pichler 36   1
1110,36 1110 1110 Renate Pichler 36   1
1760,36 1760 1760 Renate Pichler 36   1
1816,36 1816 1816 Renate Pichler 36   1
1973,36 1973 1973 Renate Pichler 36   1
2513,36 2513 2513 Renate Pichler 36   1
2750,36 2750 2750 Renate Pichler 36   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")
);