spricht

8 rows where personID = 58

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
157,58 157 157 Volker Brandt 58   1
186,58 186 186 Volker Brandt 58   1
237,58 237 237 Volker Brandt 58   1
265,58 265 265 Volker Brandt 58   1
415,58 415 415 Volker Brandt 58 Chen Lung Chung 40 1
429,58 429 429 Volker Brandt 58   1
2846,58 2846 2846 Volker Brandt 58   1
4313,58 4313 4313 Volker Brandt 58   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")
);