spricht

13 rows where personID = 265

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
948,265 948 948 Jörg Gillner 265   1
996,265 996 996 Jörg Gillner 265   1
1093,265 1093 1093 Jörg Gillner 265   1
1642,265 1642 1642 Jörg Gillner 265   1
1807,265 1807 1807 Jörg Gillner 265   1
1938,265 1938 1938 Jörg Gillner 265   1
1969,265 1969 1969 Jörg Gillner 265   1
2185,265 2185 2185 Jörg Gillner 265   1
2495,265 2495 2495 Jörg Gillner 265   1
3847,265 3847 3847 Jörg Gillner 265   1
3857,265 3857 3857 Jörg Gillner 265   1
3931,265 3931 3931 Jörg Gillner 265   1
3948,265 3948 3948 Jörg Gillner 265   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")
);