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

Close relationships within degrees of separation