Entity Unfavorable Event

DescriptionAn occurrence that causes or has the potential to cause destruction, injury, deterioration or other damage to persons or objects.

Attributes
Occurrence DateOccurrence Date
Unfavorable Event DescrUnfavorable Event Descr
Unfavorable Event NameUnfavorable Event Name

Relationship
Location is occurrence location of Unfavorable EventLocation is occurrence location of Unfavorable Event
Unfavorable Event_Unfavorable Event_FKUnfavorable Event_Unfavorable Event_FK
Unfavorable Event_Party_FKUnfavorable Event_Party_FK
Unfavorable Event_Healthcare Event_FKUnfavorable Event_Healthcare Event_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Occurrence Date
DescriptionThe date upon which the unfavorable event has occurred.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Unfavorable Event Descr
DescriptionThe textual representation of information about an occurrence of unfavorable event.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Unfavorable Event Name
DescriptionThe word or phrase identifying an occurrence of unfavorable event.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Location is occurrence location of Unfavorable Event
Is Identifying Relationshipfalse
Child TableUnfavorable Event
Child Role Nameoccurs at
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableLocation
Parent Role Nameis occurrence location of
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Unfavorable Event_Unfavorable Event_FK
Is Identifying Relationshipfalse
Child TableUnfavorable Event
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableUnfavorable Event
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Unfavorable Event_Party_FK
Is Identifying Relationshipfalse
Child TableUnfavorable Event
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableParty
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Unfavorable Event_Healthcare Event_FK
Is Identifying Relationshipfalse
Child TableUnfavorable Event
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableHealthcare Event
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE