Table Description
Social Relationship: Defines a social relationship between two household members.

There are many types of social relationships. For example, relationship can be normal, estranged, very close, violent etc.

The validations performed are: -

  • There cannot be more than one active social relationship at a time between two case participants.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Evidence::Service Layer::Entity::Household::SocialRelationship::SocialRelationship
Controlling File: Evidence\model\ServiceLayer\entity\Household\SocialRelationship\SocialRelationship.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
evidenceIDkeynoSystem generated unique identifier of the social relationship.EVIDENCE_ID SVR_INT64
fromCaseParticipantRoleIDdetailsnoThe Case Participant Role ID of the household member for whom the social relationship is being defined.CASE_PARTICIPANT_ROLE_ID SVR_INT64
toCaseParticipantRoleIDdetailsnoThe Case Participant Role ID of the household member for whom the social relationship is being defined.CASE_PARTICIPANT_ROLE_ID SVR_INT64
relationshipTypedetails Type of social relationship between the two case participants.EVD_SOCIAL_RELATIONSHIP_TYPESocialRelationshipTypeSVR_STRING<10>
commentsdetails Details relating to the social relationship.COMMENTS SVR_STRING<300>
Foreign Keys (2)
ChildParent
SocialRelationship.toCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
SocialRelationship.fromCaseParticipantRoleIDCaseParticipantRole.caseParticipantRoleID
Indices (2)
Index NameAttributes
IND__208917441toCaseParticipantRoleID
IND_1455920368fromCaseParticipantRoleID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: evidenceID
PRE_DATA_ACCESS: yes
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
removeremove Standard Operation 
Related Pages (2)