spricht

12 rows where personID = 86

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
300,86 300 300 Wolfgang Kaven 86 Roland Fabricius 28 1
309,86 309 309 Wolfgang Kaven 86 Simon Schuchardt 30 1
349,86 349 349 Wolfgang Kaven 86   1
1036,86 1036 1036 Wolfgang Kaven 86   1
1234,86 1234 1234 Wolfgang Kaven 86   1
1419,86 1419 1419 Wolfgang Kaven 86   1
2045,86 2045 2045 Wolfgang Kaven 86   1
2128,86 2128 2128 Wolfgang Kaven 86   1
2683,86 2683 2683 Wolfgang Kaven 86   1
3014,86 3014 3014 Wolfgang Kaven 86   1
3147,86 3147 3147 Wolfgang Kaven 86   1
3774,86 3774 3774 Wolfgang Kaven 86   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")
);