spricht

9 rows where personID = 413

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1388,413 1388 1388 Saskia Weckler 413   1
1592,413 1592 1592 Saskia Weckler 413   1
1771,413 1771 1771 Saskia Weckler 413   1
2483,413 2483 2483 Saskia Weckler 413   1
2500,413 2500 2500 Saskia Weckler 413   1
2605,413 2605 2605 Saskia Weckler 413   1
2928,413 2928 2928 Saskia Weckler 413   1
2958,413 2958 2958 Saskia Weckler 413   1
3446,413 3446 3446 Saskia Weckler 413   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")
);