spricht

7 rows where personID = 381

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1296,381 1296 1296 Woody Mues 381   1
2216,381 2216 2216 Woody Mues 381   1
2443,381 2443 2443 Woody Mues 381   1
2673,381 2673 2673 Woody Mues 381   1
3270,381 3270 3270 Woody Mues 381   1
3372,381 3372 3372 Woody Mues 381   1
3754,381 3754 3754 Woody Mues 381   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")
);