Entity Person Contact

DescriptionContact information that may be on file for a patient, employee, or other person of interest.

Attributes
Contact ReasonContact Reason
Contact SeqContact Seq
Contact Title NameContact Title Name

Relationship
Person Contact_Contact_FKPerson Contact_Contact_FK
Person Contact Person FKPerson Contact Person FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Contact Reason
DescriptionIndicates why and in what circumstances the person should be contacted.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Contact Seq
DescriptionIndicates the order in which to communicate with this person in a list of contacts.
Data TypeStandards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Contact Title Name
DescriptionThe contact person's title.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Person Contact_Contact_FK
Is Identifying Relationshipfalse
Child TablePerson Contact
Child Role Namehas contact
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableContact
Parent Role Nameis contact for
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Person Contact Person FK
Is Identifying Relationshipfalse
Child TablePerson Contact
Child Role Nameuses person
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePerson
Parent Role Nameis person for
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE