spricht

30 rows where personID = 401

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1353,401 1353 1353 Robert Missler 401   1
1773,401 1773 1773 Robert Missler 401   1
1794,401 1794 1794 Robert Missler 401   1
1997,401 1997 1997 Robert Missler 401   1
2012,401 2012 2012 Robert Missler 401   1
2503,401 2503 2503 Robert Missler 401   1
2922,401 2922 2922 Robert Missler 401   1
2991,401 2991 2991 Robert Missler 401   1
3013,401 3013 3013 Robert Missler 401   1
3194,401 3194 3194 Robert Missler 401   1
3319,401 3319 3319 Robert Missler 401   1
3772,401 3772 3772 Robert Missler 401   1
3796,401 3796 3796 Robert Missler 401   1
3812,401 3812 3812 Robert Missler 401   1
3824,401 3824 3824 Robert Missler 401   1
3825,401 3825 3825 Robert Missler 401   1
3837,401 3837 3837 Robert Missler 401   1
3859,401 3859 3859 Robert Missler 401   1
3887,401 3887 3887 Robert Missler 401   1
3961,401 3961 3961 Robert Missler 401   1
3998,401 3998 3998 Robert Missler 401   1
4007,401 4007 4007 Robert Missler 401   1
4138,401 4138 4138 Robert Missler 401   1
4139,401 4139 4139 Robert Missler 401   1
4188,401 4188 4188 Robert Missler 401   1
4403,401 4403 4403 Robert Missler 401   1
4435,401 4435 4435 Robert Missler 401   1
4469,401 4469 4469 Robert Missler 401   1
4496,401 4496 4496 Robert Missler 401   1
5009,401 5009 5009 Robert Missler 401   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")
);