spricht

13 rows where personID = 236

✎ View and edit SQL

This data as json, CSV (advanced)

Link sprechrolleID personID pseudonymID position
860,236 860 860 Katja Brügger 236   1
1122,236 1122 1122 Katja Brügger 236   1
1591,236 1591 1591 Katja Brügger 236   1
2089,236 2089 2089 Katja Brügger 236   1
2121,236 2121 2121 Katja Brügger 236   1
2453,236 2453 2453 Katja Brügger 236   1
2468,236 2468 2468 Katja Brügger 236   1
2923,236 2923 2923 Katja Brügger 236   1
2986,236 2986 2986 Katja Brügger 236   1
3090,236 3090 3090 Katja Brügger 236   1
3165,236 3165 3165 Katja Brügger 236   1
3434,236 3434 3434 Katja Brügger 236   1
5006,236 5006 5006 Katja Brügger 236   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")
);