spricht

11 rows where personID = 354

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
1199,354 1199 1199 Anja Topf 354   1
1295,354 1295 1295 Anja Topf 354   1
1306,354 1306 1306 Anja Topf 354   1
1476,354 1476 1476 Anja Topf 354   1
1503,354 1503 1503 Anja Topf 354   1
1578,354 1578 1578 Anja Topf 354   1
2348,354 2348 2348 Anja Topf 354   1
2675,354 2675 2675 Anja Topf 354   1
3389,354 3389 3389 Anja Topf 354   1
3436,354 3436 3436 Anja Topf 354   1
5152,354 5152 5152 Anja Topf 354   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")
);