spricht

6 rows where personID = 148

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
594,148 594 594 Lutz Harder 148 Marco Kröger 46 1
637,148 637 637 Lutz Harder 148   1
1638,148 1638 1638 Lutz Harder 148   1
1837,148 1837 1837 Lutz Harder 148   1
2413,148 2413 2413 Lutz Harder 148   1
2622,148 2622 2622 Lutz Harder 148   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")
);