tbl_taskcustomfieldsvalue

-1 rows


Description

Module: Task Management
Purpose: Stores the actual values entered by users for custom fields in daily tasks.
Data: Each row represents the value of a specific custom field for a daily task.
Process Usage:
- Records user input for text, date, or selectable custom fields.
- For selection fields, stores both the option ID and the selected value.
Key Points:
- Links custom field values to a specific daily task.
- Supports auditing, reporting, and template-based task creation.
Business Impact: Enables accurate capture of user-provided task details and supports data-driven task analysis.

Columns

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

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

Daily Task ID
Meaning: References the specific daily task.
Usage: Maps the custom field value to the associated daily task record in tbl_task.
customfieldid int8 19 √ null

Custom Field ID
Meaning: References the custom field definition.
Usage: Determines which field this value corresponds to.
customfieldoptionid text 2147483647 √ null

Custom Field Option ID
Meaning: If the field is a selection type, stores the ID of the selected option.
Usage: Populates dropdown or multi-select selections with the user-chosen option.
customvalue text 2147483647 √ null

Custom Value
Meaning: Stores the actual value entered by the user.
Usage: Contains either text/date input or the text of the selected option.
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_taskcustomfieldsvalue_id Primary key Asc id

Relationships

Close relationships within degrees of separation