spricht

10 rows where personID = 679

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
2469,679 2469 2469 Birte Kretschmer 679   1
2887,679 2887 2887 Birte Kretschmer 679   1
2953,679 2953 2953 Birte Kretschmer 679   1
3007,679 3007 3007 Birte Kretschmer 679   1
3153,679 3153 3153 Birte Kretschmer 679   1
3193,679 3193 3193 Birte Kretschmer 679   1
3214,679 3214 3214 Birte Kretschmer 679   1
3276,679 3276 3276 Birte Kretschmer 679   1
3374,679 3374 3374 Birte Kretschmer 679   1
5063,679 5063 5063 Birte Kretschmer 679   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")
);