tbl_templatecustomfieldvaluehistory

-1 rows


Description

Module: Task Management
Purpose: Stores historical snapshots of template custom field values.
Data: Each row represents a version of a custom field associated with a template at a specific point in time.
Process Usage:
- Tracks changes to template custom fields, including label updates, required flags, status changes, default values, and options.
- Supports audit and rollback of template custom field configurations.
Key Points:
- Maintains a history of all modifications to template custom fields.
- Useful for troubleshooting, auditing, and reviewing changes in template configuration.
Business Impact: Ensures accountability and traceability for changes in task template definitions, improving governance and compliance.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each custom field history record.

templateid int8 19 null

Template ID
Meaning: References the parent template to which this custom field belongs.
Usage: Maps the history record to the template for which the custom field was configured.

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 template custom field.

templatehistoryid int8 19 null

Template History ID
Meaning: References the historical version of the template.
Usage: Connects this custom field history record to the corresponding template history snapshot.

templatecustomfieldid int8 19 null

Template Custom Field ID
Meaning: References the original custom field definition.
Usage: Tracks which custom field this history record corresponds to.

templatecustomfieldoptionid text 2147483647 null

Custom Field Option IDs
Meaning: Stores option IDs for selectable fields at the time of the snapshot.
Usage: Preserves the selectable options associated with the custom field during this historical version.

customfieldlabel text 2147483647 null

Custom Field Label
Meaning: Stores the name of the custom field at the time of the snapshot.
Usage: Reflects any changes made to the label for auditing or rollback purposes.

isrequired bool 1 null

Required flag
Meaning: Indicates whether the custom field was mandatory at the time of the snapshot.
Usage: Preserves historical validation rules for the field.

status bool 1 null

Active flag
Meaning: Indicates whether the custom field was active and displayed during task creation at the time of the snapshot.
Usage: Tracks visibility status of the field for historical reference.

customfielddefaultvalue text 2147483647 null

Default value
Meaning: Pre-filled value of the custom field at the time of the snapshot.
Usage: Maintains historical default values to support auditing and rollback.

createdby varchar 500 null
modifiedby varchar 500 null
createddate timestamp 29,6 null
modifieddate timestamp 29,6 null

Indexes

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

Relationships