spricht

12 rows where personID = 31

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
51,31 51 51 Horst Frank 31   1
77,31 77 77 Horst Frank 31   1
102,31 102 102 Horst Frank 31   1
122,31 122 122 Horst Frank 31   1
160,31 160 160 Horst Frank 31   1
173,31 173 173 Horst Frank 31   1
222,31 222 222 Horst Frank 31   1
263,31 263 263 Horst Frank 31   1
381,31 381 381 Horst Frank 31   1
431,31 431 431 Horst Frank 31   1
446,31 446 446 Horst Frank 31   1
481,31 481 481 Horst Frank 31   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")
);