spricht

18 rows where personID = 1100

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
4515,1100 4515 4515 Roland Geiger 1100   1
4550,1100 4550 4550 Roland Geiger 1100   1
4587,1100 4587 4587 Roland Geiger 1100   1
4655,1100 4655 4655 Roland Geiger 1100   1
4673,1100 4673 4673 Roland Geiger 1100   1
4700,1100 4700 4700 Roland Geiger 1100   1
4749,1100 4749 4749 Roland Geiger 1100   1
4777,1100 4777 4777 Roland Geiger 1100   1
4803,1100 4803 4803 Roland Geiger 1100   1
4835,1100 4835 4835 Roland Geiger 1100   1
4848,1100 4848 4848 Roland Geiger 1100   1
4855,1100 4855 4855 Roland Geiger 1100   1
4888,1100 4888 4888 Roland Geiger 1100   1
4913,1100 4913 4913 Roland Geiger 1100   1
4925,1100 4925 4925 Roland Geiger 1100   1
4983,1100 4983 4983 Roland Geiger 1100   1
5094,1100 5094 5094 Roland Geiger 1100   1
5142,1100 5142 5142 Roland Geiger 1100   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")
);