Entity Accident

DescriptionAn unfavorable event that causes unintentional injury to a person due to an unforeseen external circumstance.

For example:
A pedestrian is struck by a passing vehicle resulting in their admission to an emergency department.

Attributes
Accident CauseAccident Cause
Type of Accident LocationType of Accident Location

Relationship
Person is affected by AccidentPerson is affected by Accident

Generalization
Accident_Unfavorable Event_GenAccident_Unfavorable Event_Gen

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Accident Cause
DescriptionIndicates the unexpected and unforeseen cause of an accident. The 'means' that caused the mishap must be accidental in order to claim benefits under a policy. Therefore, also referred to as 'accidental means'.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Type of Accident Location
DescriptionIndicates the type of location where accident occurred.

For example:
Farm
Outdoors
Public street
Residence
Work
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Person is affected by Accident
Is Identifying Relationshipfalse
Child TableAccident
Child Role Nameaffects
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePerson
Parent Role Nameis affected by
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Accident_Unfavorable Event_Gen
SupertypeUnfavorable Event
SubtypeAccident
Transform AsTABLE