spricht

10 rows where personID = 620

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
2164,620 2164 2164 Stephan Schad 620   1
2569,620 2569 2569 Stephan Schad 620   1
2634,620 2634 2634 Stephan Schad 620   1
2656,620 2656 2656 Stephan Schad 620   1
2696,620 2696 2696 Stephan Schad 620   1
2952,620 2952 2952 Stephan Schad 620   1
3343,620 3343 3343 Stephan Schad 620   1
3573,620 3573 3573 Stephan Schad 620   1
3691,620 3691 3691 Stephan Schad 620   1
3705,620 3705 3705 Stephan Schad 620   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")
);