tbl_aboutyourself

-1 rows


Description

Module: Employee Profile/Edit Profile - Employee Self-Description
Purpose: Stores the employee’s personal, often free-text, description or narrative about themselves, their interests, professional summary, or skills (the “About Me” section of a profile).
Data: Captures the unique ID, the employee ID, the related company ID, and the text content of the employee’s self-description (SelfDetail).
Process Usage:
- Profile Display: Used to populate the “About Me” section on an employee’s internal profile, often visible to colleagues and managers.
- Directory/Search: Provides unstructured text that can be used to search for employees based on skills or interests not captured in formal fields.
- Personalization: Allows employees to add a personal touch to their official HR record.
Key Points:
- Unstructured Data: The SelfDetail column is free-text, not a structured data point.
- Linked to the employee master record via EmployeeID.
Business Impact: Enhances internal networking, team building, and understanding of employee capabilities beyond their job title.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_aboutyourself_id_seq'::regclass)

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this self-description record.
companyid int4 10 null
tbl_companymaster.companyid Implied Constraint R

FK: public.tbl_CompanyDetail.CompID
Meaning: The ID of the company this employee is associated with (used for multi-tenant isolation).
employeeid varchar 500 null
tbl_employee.employeeid fk_tbl_aboutyourself_employeeid R

FK: public.tbl_employee.employeeid
Meaning: The Employee ID to whom this self-description belongs.
selfdetail varchar 2000 √ null

The actual free-text content provided by the employee as their “About Me” or self-summary.
createddate timestamp 29,6 √ null

Timestamp of when the initial self-detail record was created.
Format: Timestamp with timezone.
createdby varchar 200 √ null

FK: public.tbl_employee.employeeid or public.tbl_userlogin.id
Meaning: The user who initially created the profile record (typically the employee or an administrative proxy).
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the self-detail record.
Format: Timestamp with timezone.
modifiedby varchar 50 √ null

FK: public.tbl_employee.employeeid or public.tbl_userlogin.id
Meaning: The user who last updated the self-detail record.

Indexes

Constraint Name Type Sort Column(s)
tbl_aboutyourself_pk_tbl_aboutyourself Primary key Asc id

Relationships

Close relationships within degrees of separation