tbl_employeereferences

-1 rows


Description

Module: Employee Profile
Purpose: Stores reference details provided by employees.
Data: One row is created for each reference associated with an employee.
Process Usage:
- Captures reference name, contact details, and email.
- Tracks references for verification and HR processes.
Key Points:
- Links references to employees via employeeid.
- Supports HR verification and historical tracking through the history table.
Business Impact: Ensures proper tracking of employee references for verification, onboarding, and compliance.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
emprefid bigserial 19 √ nextval('tbl_employeereferences_emprefid_seq'::regclass)
tbl_employeereferenceshistory.emprefid fk_tbl_employeereferenceshistory R

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

Employee ID
Format: VARCHAR(20)
Meaning: References the employee to whom this reference belongs.
Usage: Links reference records to the corresponding employee.
name varchar 50 null

Reference Name
Format: VARCHAR(50)
Meaning: Name of the reference person.
Usage: Captures the reference person’s name.
address varchar 2147483647 √ null

Reference Address
Format: VARCHAR
Meaning: Address of the reference person.
Usage: Used to contact the reference if needed.
phoneno varchar 15 √ null

Reference Phone Number
Format: VARCHAR(15)
Meaning: Landline number of the reference person.
Usage: Used for verification purposes.
mobileno varchar 15 √ null

Reference Mobile Number
Format: VARCHAR(15)
Meaning: Mobile number of the reference person.
Usage: Used for verification or contact.
email varchar 100 √ null

Reference Email
Format: VARCHAR(100)
Meaning: Email of the reference person.
Usage: Used for verification or contact.
com1 varchar 2147483647 √ null

Not Used column
Kept for schema consistency.
com2 varchar 2147483647 √ null

Not Used column
Kept for schema consistency.
com3 varchar 2147483647 √ null

Not Used column
Kept for schema consistency.
com4 varchar 2147483647 √ null

Not Used column
Kept for schema consistency.
com5 varchar 2147483647 √ null

Not Used column
Kept for schema consistency.
com6 varchar 2147483647 √ null

Not Used column
Kept for schema consistency.
com7 varchar 2147483647 √ null

Not Used column
Kept for schema consistency.
com8 varchar 2147483647 √ null

Not Used column
Kept for schema consistency.
com9 varchar 2147483647 √ null

Not Used column
Kept for schema consistency.
com10 varchar 2147483647 √ null

Not Used column
Kept for schema consistency.
createdby varchar 20 √ null

Created By
Format: VARCHAR(20)
Meaning: User who created this record.
Usage: For audit purposes.
createdon timestamp 29,6 √ null

Created On
Format: TIMESTAMP
Meaning: Timestamp when the record was created.
Usage: For audit purposes.
modifiedby varchar 100 √ null

Modified By
Format: VARCHAR(100)
Meaning: User who last modified this record.
Usage: For audit purposes.
modifiedon timestamp 29,6 √ null

Modified On
Format: TIMESTAMP
Meaning: Timestamp when the record was last modified.
Usage: For audit purposes.

Indexes

Constraint Name Type Sort Column(s)
tbl_employeereferences_pk_tbl_employeereferences Primary key Asc emprefid

Relationships

Close relationships within degrees of separation