|
This entity holds the address of the person. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
Yes |
|
This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
Yes |
|
A system generated identity for the personal address to distinguish each employee. It also acts as a primary key for the PersonalAddress table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(150) |
|
Mandatory |
No |
|
This attribute stores the address of the contact person. This address excludes the postal code and country. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
This field holds the country of the address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
This attribute would record the city name. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
Shows the state of the address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
This attribute holds the postal code of the address. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Indicates if the provided address can be used as a Mailing address. There can only be one mailing address for a particular person. It is in a form of a checkbox. |
|
Name |
|
|
Code |
|
|
Data Type |
char(150) |
|
Mandatory |
No |
|
Second line for the address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(150) |
|
Mandatory |
No |
|
Third line for the address. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
Name |
|
|
Code |
|
|
Data Type |
char(50) |
|
Mandatory |
No |
|
Enables the customer to customize the section. String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask for the name of a previous employer. |
|
|
|