okr_key_result_custom_fields_mapping

-1 rows


Description

Module: OKR
Purpose: Stores the actual data values entered into custom fields specifically configured for an OKR Key Result, representing the current or latest state of that custom data.
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:
- Live Data: Used to fetch the current values for a Key Result’s custom attributes when viewing or updating the OKR.
- Dynamic Fields: Provides flexibility to track non-standard attributes necessary for OKR tracking and evaluation.
Key Points:
- Value Store: This table holds the instance data/values, not the field definition itself.
- Likely Current State: This table tracks the live, ongoing data for the custom fields attached to a Key Result.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr_key_result_custom_fields_mapping_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 Primary key Asc id

Relationships

Close relationships within degrees of separation