spricht

10 rows where personID = 351

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1189,351 1189 1189 Tobias Schmidt 351   1
1691,351 1691 1691 Tobias Schmidt 351   1
1953,351 1953 1953 Tobias Schmidt 351   1
2176,351 2176 2176 Tobias Schmidt 351   1
2279,351 2279 2279 Tobias Schmidt 351   1
2636,351 2636 2636 Tobias Schmidt 351   1
2720,351 2720 2720 Tobias Schmidt 351   1
2834,351 2834 2834 Tobias Schmidt 351   1
2946,351 2946 2946 Tobias Schmidt 351   1
3979,351 3979 3979 Tobias Schmidt 351   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")
);