okr_key_result_custom_fields_mapping_assign

-1 rows


Description

Module: OKR
Purpose: Stores the actual data values entered into custom fields specifically configured for an OKR Key Result at the point of assignment or initial creation.
Data: Links a specific Key Result (key_result_id) to a custom field definition (custom_field_id) and records the value (custom_field_value) provided by the user.
Process Usage:
- Initial Data Capture: Used to store configuration details or metadata when a Key Result is first defined or assigned.
- Flexibility: Allows for tracking non-standard, context-specific data points for Key Results (e.g., target market, project code, or specific metric link).
Key Points:
- Value Store: This table holds the instance data/values, not the field definition itself.
- Likely Initial State: The “assign” suffix suggests these values represent the state at assignment/creation.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this custom field value record.
key_result_id int8 19 null

FK: public.tbl_okr_key_result.id (Implied)
Meaning: The ID of the specific Key Result this custom field value belongs to.
custom_field_id int8 19 null

FK: public.tbl_custom_fields.id (Implied)
Meaning: The ID of the master custom field definition this value is for.
custom_field_value varchar 500 √ null

The specific value entered by the user for this custom field, linked to the Key Result.
createddate timestamp 29,6 √ null
createdby varchar 50 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null

Indexes

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

Relationships

Close relationships within degrees of separation