tbl_okr_questionaries

-1 rows


Description

Module: Objectives and key results (OKR)
Purpose: Stores the granular definition of questions that belong to a master OKR Review Questionnaire Template.
Data: Captures the full question text, its display sequence, the weight assigned for scoring, and the required format of the answer.
Process Usage:
- Form Content: Used to populate the list of items presented in an OKR performance review form.
- Scoring Logic: The weightage and answer_type are essential inputs for calculating the final review score.
- Links to the template header record via master_id (likely from tbl_okr_questionaries_master).
Key Points:
- Template Component: Defines the specific content of the “questions” part of the OKR review process.
- The structure mirrors that of other template detail tables for consistency.
Business Impact: Ensures that the performance review is standardized, structured, and quantifiable across all employees.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific question within the template.
index_number int4 10 null

The display order or sequential position of the question within the questionnaire.
master_id int8 19 null

FK: public.tbl_okr_questionaries_master.id
Meaning: The ID of the parent master questionnaire template this question belongs to.
question_title varchar 500 null

The full text or title of the question to be presented in the review form.
weightage float8 17,17 √ null

The numerical weight assigned to this question for use in calculating the overall review score.
answer_type varchar 20 √ null

The required format of the response for this question (e.g., RATING_SCALE, FREE_TEXT, YES_NO).
is_delete bool 1 √ null

Soft-delete flag: Indicates if this question has been logically removed from the master template definition.
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_questionaries Primary key Asc id

Relationships

Close relationships within degrees of separation