tbl_employee_delete_info

-1 rows


Description

Module: Employee
Purpose: Tracks deleted employee records and related structure.
Data: One row is created for each deleted employee, storing all relevant employee information.
Process Usage:
- When an employee is deleted, their personal and structural data is captured.
- Employee details and structure are stored in JSON format for audit and recovery.
Key Points:
- Maintains a historical snapshot of deleted employee data.
- Supports auditing, compliance, and potential restoration processes.
Business Impact: Ensures traceability and accountability for employee deletions, aiding compliance and internal audits.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each deleted employee record.
employeeid varchar 50 null

Deleted employee ID
Format: VARCHAR(50)
Meaning: The identifier of the employee who was deleted.
Usage: Used to track and reference the deleted employee.
employee_info varchar 2147483647 null

JSON snapshot of employee details.
Format: VARCHAR / JSON text
Meaning: Contains the full record from the tbl_employee table at the time of deletion.
Usage: Enables point-in-time reconstruction and auditing of deleted employee data.
employeestructure_info varchar 2147483647 null

JSON snapshot of employee structure.
Format: VARCHAR / JSON text
Meaning: Contains the relevant data from the tbl_employeestructure table related to the deleted employee.
Usage: Supports auditing and review of the organizational structure associated with the deleted employee.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation