tbl_taskhistory

-1 rows


Description

Module: Task Management
Purpose: Maintains history of task changes from tbl_task.
Data: Each entry represents a snapshot of a task whenever a modification occurs.
Process Usage:
- Tracks changes in task metadata, description, deadlines, and attachments.
- Provides audit trail for task management and compliance.
Key Points:
- No foreign keys for review_id in history table; snapshot is independent.
- Useful for reports, rollback, and auditing purposes.
Business Impact: Ensures traceability and accountability in task management processes.

Columns

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

Primary key
Format: BIGSERIAL
Meaning: Unique identifier for each task history record.
historyid int8 19 √ null
tbl_shiftmasterv1history.historyid Implied Constraint R

History ID
Format: BIGINT
Meaning: Original task ID in tbl_task corresponding to this snapshot.
taskname varchar 150 null

Task Name
Format: VARCHAR(150)
Meaning: Name of the task at the time of the snapshot.
employeeid varchar 500 null
tbl_employee.employeeid Implied Constraint R

Employee ID
Format: VARCHAR(500)
Meaning: Employee assigned to the task when this snapshot was created.
projectid int8 19 √ null

Project ID
Format: BIGINT
Meaning: Project associated with the task at this snapshot.
tasktype varchar 100 null

Task Type
Format: VARCHAR(100)
Meaning: RECURRING or NON_RECURRING as recorded at snapshot time.
recurringparentid int8 19 √ null

Recurring Parent ID
Format: BIGINT
Meaning: Original parent ID if task is part of a recurring series.
templateid int8 19 √ null

Template ID
Format: BIGINT
Meaning: Template used for task creation at the snapshot.
startdate date 13 √ null

Start Date
Format: DATE
Meaning: Task start date at the time of the snapshot.
enddate date 13 √ null

End Date
Format: DATE
Meaning: Task end date at snapshot time.
totalspenttime int8 19 √ null

Total Time Spent
Format: BIGINT
Meaning: Minutes spent on the task up to snapshot time.
taskdescription varchar 1000 √ null

Task Description
Format: VARCHAR(1000)
Meaning: Task details at the time of the snapshot.
extendedenddate date 13 √ null

Extended End Date
Format: DATE
Meaning: Extended deadline if updated when snapshot was created.
attachment text 2147483647 √ null

Attachments
Format: TEXT (JSON)
Meaning: JSON array of uploaded files at snapshot time.
createddate timestamp 29,6 √ null
createdby varchar 500 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 500 √ null

Indexes

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

Relationships

Close relationships within degrees of separation