Entity PersonalContact

Description of Entity PersonalContact

This entity holds the contact number of the person. Storing the contact this way would allow the person to have more than one or two contact numbers.


List of all Dependencies of the Entity PersonalContact

Name

Code

Class Name

Relation_1492

Relation_1492

Reference

Relation_1494

Relation_1494

Reference


List of Attributes of the Entity PersonalContact

Name

Code

PersonalSysId

PersonalSysId

Personal Contact ID

PersonalContactId

Contact > Number

ContactNumber

Extension

Extension


Entity Attribute PersonalSysId of the Entity PersonalContact

Card of Attribute PersonalSysId of the Entity PersonalContact

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

Yes


Description of Attribute PersonalSysId of the Entity PersonalContact

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.


Entity Attribute Personal Contact ID of the Entity PersonalContact

Card of Attribute Personal Contact ID of the Entity PersonalContact

Name

Personal Contact ID

Code

PersonalContactId

Data Type

integer

Mandatory

Yes


Description of Attribute Personal Contact ID of the Entity PersonalContact

Shows the identity of the personal contact. This attribute is the primary key to the PersonalContact table.


Entity Attribute Contact > Number of the Entity PersonalContact

Card of Attribute Contact > Number of the Entity PersonalContact

Name

Contact > Number

Code

ContactNumber

Data Type

char(30)

Mandatory

No


Description of Attribute Contact > Number of the Entity PersonalContact

This field contains the contact number for the person.


Entity Attribute Extension of the Entity PersonalContact

Card of Attribute Extension of the Entity PersonalContact

Name

Extension

Code

Extension

Data Type

char(10)

Mandatory

No


Description of Attribute Extension of the Entity PersonalContact

This attribute would record the extension of the contact number. This extension should be left empty if it is not applicable.