tbl_taskcustomfieldsvaluehistory

-1 rows


Description

Module: Task Management
Purpose: Stores historical snapshots of custom field values for daily tasks.
Data: Each row represents a version of a custom field value at a specific point in time.
Process Usage:
- Tracks changes to custom field values in daily tasks.
- Supports auditing and rollback of user-entered data.
Key Points:
- Links historical values to the corresponding daily task and task history.
- Maintains option IDs and values for selection-type fields.
Business Impact: Ensures accountability and traceability for changes in task data, aiding reporting and compliance.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each historical custom field value record.
dailytaskid int8 19 √ null

Daily Task ID
Meaning: References the specific daily task.
Usage: Connects the history record to the original task.
dailytaskhistoryid int8 19 √ null

Daily Task History ID
Meaning: References the historical snapshot of the daily task.
Usage: Maps this custom field value history to the specific task history record.
historyid int8 19 √ null
tbl_shiftmasterv1history.historyid Implied Constraint R

History ID
Meaning: Identifier for the historical snapshot.
Usage: Distinguishes different historical versions of the same custom field value.
customfieldid int8 19 √ null

Custom Field ID
Meaning: References the original custom field definition.
Usage: Tracks which field this history record corresponds to.
customfieldoptionid text 2147483647 √ null

Custom Field Option ID
Meaning: Stores the option ID if the field is a selection type.
Usage: Preserves the option selection at the time of this historical record.
customvalue text 2147483647 √ null

Custom Value
Meaning: Stores the value entered by the user at the time of this snapshot.
Usage: Maintains historical input for auditing and rollback purposes.
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_taskcustomfieldsvaluehistory_id Primary key Asc id

Relationships

Close relationships within degrees of separation