spricht

6 rows where personID = 364

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1240,364 1240 1240 Regina Lemnitz 364   1
1966,364 1966 1966 Regina Lemnitz 364   1
2211,364 2211 2211 Regina Lemnitz 364   1
2512,364 2512 2512 Regina Lemnitz 364   1
2970,364 2970 2970 Regina Lemnitz 364   1
3689,364 3689 3689 Regina Lemnitz 364   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")
);