tbl_okr_template_questionaries_assign

-1 rows


Description

Module: Objectives and key results (OKR)
Purpose: Stores the specific configuration of questions as they are linked to an active, assigned OKR review cycle or assessment instance.
Data: This table is a snapshot/copy of the master question details, ensuring immutability for live review forms.
Process Usage:
- Review Instantiation: Created when an OKR review cycle is launched and assigned to employees.
- Provides the precise, stable list of questions to be used for a given review, even if the master template is later modified.
Key Points:
- Version Control: Decouples active reviews from future template changes.
- The master_id likely links to the specific assigned review record rather than the master template ID.
Business Impact: Guarantees data integrity and consistency for all in-progress performance reviews.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this assigned question instance.
master_id int8 19 null

FK: ID of the parent assigned review instance (e.g., public.tbl_okr_review_assign.id).
Meaning: The ID of the specific active OKR review assignment this question belongs to.
index_number int4 10 null

The display order of the question in the assigned review form.
question_title varchar 500 null

The text of the question as it appears in the active review form.
weightage float8 17,17 √ null

The weight of the question used for calculating the score of the specific assigned review.
answer_type varchar 20 √ null

The required response format for this question in the active review.
is_delete bool 1 √ null

Soft-delete flag: Indicates if this question was logically excluded from the assigned review, even if present in the master.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation