spricht

10 rows where personID = 43

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
101,43 101 101 Peter Kirchberger 43 Alexander Stubbe 14 1
303,43 303 303 Peter Kirchberger 43   1
333,43 333 333 Peter Kirchberger 43   1
382,43 382 382 Peter Kirchberger 43   1
438,43 438 438 Peter Kirchberger 43   1
841,43 841 841 Peter Kirchberger 43   1
2054,43 2054 2054 Peter Kirchberger 43   1
2829,43 2829 2829 Peter Kirchberger 43   1
3070,43 3070 3070 Peter Kirchberger 43   1
4047,43 4047 4047 Peter Kirchberger 43   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")
);