tbl_okr_training

-1 rows


Description

Module: OKR
Purpose: Stores the individual training modules, articles, or resources (videos, documents) provided to employees to educate them on the Objectives and Key Results (OKR) framework and system usage.
Data: Captures the title/name of the training item, its categorization, and a detailed description or summary of the content.
Process Usage:
- Learning Management: Used by the OKR module to display relevant training materials to users (managers, employees) on how to effectively use the system and methodology.
- Content Organization: Links content to a master category (e.g., “OKR Basics,” “Key Result Measurement”) for easy navigation.
Key Points:
- Resource Hub: Acts as the central hub for self-service learning related to performance goals.
- The description likely contains the content itself, a link to the content, or a summary.
Business Impact: Ensures employees are properly educated on the OKR process, leading to better goal alignment and higher quality OKR submissions.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific training resource.
category_id int8 19 null
tbl_okr_category.id tbl_okr_training_category_id_fkey C

FK: public.tbl_okr_training_category.id (Implied)
Meaning: The ID of the category this training resource belongs to (e.g., “Beginner,” “Advanced,” “System How-To”).
name varchar 255 null

The title or name of the training resource (e.g., “Introduction to Objectives,” “Measuring Quantitative Key Results”).
description text 2147483647 √ null

A detailed description of the training content, or a field containing the actual content, summary, or a direct link/reference to the training material.
createdby varchar 100 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 100 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation