spricht

7 rows where personID = 550

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1905,550 1905 1905 Simona Pahl 550   1
2454,550 2454 2454 Simona Pahl 550   1
2839,550 2839 2839 Simona Pahl 550   1
3167,550 3167 3167 Simona Pahl 550   1
3275,550 3275 3275 Simona Pahl 550   1
3320,550 3320 3320 Simona Pahl 550   1
3474,550 3474 3474 Simona Pahl 550   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")
);