spricht

14 rows where personID = 112

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
465,112 465 465 Eckart Dux 112   1
668,112 668 668 Eckart Dux 112   1
734,112 734 734 Eckart Dux 112   1
1270,112 1270 1270 Eckart Dux 112   1
1615,112 1615 1615 Eckart Dux 112   1
1700,112 1700 1700 Eckart Dux 112   1
1920,112 1920 1920 Eckart Dux 112   1
2346,112 2346 2346 Eckart Dux 112   1
2424,112 2424 2424 Eckart Dux 112   1
2459,112 2459 2459 Eckart Dux 112   1
2919,112 2919 2919 Eckart Dux 112   1
3015,112 3015 3015 Eckart Dux 112   1
3248,112 3248 3248 Eckart Dux 112   1
3965,112 3965 3965 Eckart Dux 112   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")
);