tbl_employeeguarantors

-1 rows


Description

Module: Employee Profile
Purpose: Stores guarantor details of employees.
Data: One row per guarantor associated with an employee.
Process Usage:
- Maintains employee guarantor personal and contact information.
- Can include office/home addresses, phone numbers, and email.
Key Points:
- Supports multiple guarantors per employee.
- Most columns com1-com10, created/modified info are reserved for internal use or future functionality.
Business Impact: Ensures HR has verified guarantor information for compliance or emergency purposes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
empguarid bigserial 19 √ nextval('tbl_employeeguarantors_empguarid_seq'::regclass)
tbl_employeeguarantorshistory.empguarid fk_tbl_employeeguarantorshistory R

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each guarantor record.
employeeid varchar 20 null
tbl_employee_previous_pf.employeeid Implied Constraint R

Employee ID
Format: VARCHAR(20)
Meaning: References the employee linked to this guarantor.
Usage: Connects guarantor record to the corresponding employee.
name varchar 50 null

Guarantor Name
Format: VARCHAR(50)
Meaning: Name of the guarantor associated with employee.
officeaddress varchar 2147483647 √ null

Office Address
Format: VARCHAR
Meaning: Guarantor office location.
homeaddress varchar 2147483647 √ null

Home Address
Format: VARCHAR
Meaning: Guarantor residential address.
officephoneno varchar 15 √ null

Office Phone Number
Format: VARCHAR(15)
Meaning: Guarantor office phone number.
mobileno varchar 15 √ null

Mobile Number
Format: VARCHAR(15)
Meaning: Guarantor mobile phone number.
email varchar 100 √ null

Email Address
Format: VARCHAR(100)
Meaning: Guarantor email address.
com1 varchar 2147483647 √ null

Reserved Column
Not used in code.
com2 varchar 2147483647 √ null

Reserved Column
Not used in code.
com3 varchar 2147483647 √ null

Reserved Column
Not used in code.
com4 varchar 2147483647 √ null

Reserved Column
Not used in code.
com5 varchar 2147483647 √ null

Reserved Column
Not used in code.
com6 varchar 2147483647 √ null

Reserved Column
Not used in code.
com7 varchar 2147483647 √ null

Reserved Column
Not used in code.
com8 varchar 2147483647 √ null

Reserved Column
Not used in code.
com9 varchar 2147483647 √ null

Reserved Column
Not used in code.
com10 varchar 2147483647 √ null

Reserved Column
Not used in code.
createdby varchar 20 √ null

Created By
Format: VARCHAR(20)
Usage: Not currently used in code.
createdon timestamp 29,6 √ null

Created Date
Format: TIMESTAMP
Usage: Not currently used in code.
modifiedby varchar 20 √ null

Modified By
Format: VARCHAR(20)
Usage: Not currently used in code.
modifiedon timestamp 29,6 √ null

Modified Date
Format: TIMESTAMP
Usage: Not currently used in code.

Indexes

Constraint Name Type Sort Column(s)
tbl_employeeguarantors_pk_tbl_employeeguarantors Primary key Asc empguarid

Relationships

Close relationships within degrees of separation