spricht

6 rows where personID = 378

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1287,378 1287 1287 Corinna Wodrich 378   1
1962,378 1962 1962 Corinna Wodrich 378   1
1985,378 1985 1985 Corinna Wodrich 378   1
2013,378 2013 2013 Corinna Wodrich 378   1
2249,378 2249 2249 Corinna Wodrich 378   1
2998,378 2998 2998 Corinna Wodrich 378   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")
);