spricht

16 rows where personID = 32

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: position

Link sprechrolleID personID pseudonymID position
52,32 52 52 Lothar Grützner 32   1
79,32 79 79 Lothar Grützner 32 Hans Meinhardt 5 1
226,32 226 226 Lothar Grützner 32   1
257,32 257 257 Lothar Grützner 32   1
280,32 280 280 Lothar Grützner 32   1
360,32 360 360 Lothar Grützner 32   1
370,32 370 370 Lothar Grützner 32   1
398,32 398 398 Lothar Grützner 32   1
402,32 402 402 Lothar Grützner 32   2
529,32 529 529 Lothar Grützner 32   1
707,32 707 707 Lothar Grützner 32   1
1108,32 1108 1108 Lothar Grützner 32   1
1196,32 1196 1196 Lothar Grützner 32   1
1619,32 1619 1619 Lothar Grützner 32   1
1740,32 1740 1740 Lothar Grützner 32   1
1777,32 1777 1777 Lothar Grützner 32   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")
);