spricht

8 rows where personID = 793

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
3066,793 3066 3066 Achim Buch 793   1
3529,793 3529 3529 Achim Buch 793   1
3544,793 3544 3544 Achim Buch 793   1
3604,793 3604 3604 Achim Buch 793   1
3677,793 3677 3677 Achim Buch 793   1
3707,793 3707 3707 Achim Buch 793   1
3724,793 3724 3724 Achim Buch 793   1
5171,793 5171 5171 Achim Buch 793   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")
);