hr.competencies
Schema: hr
English table: hr.competencies
Italian original table: hr.competenze
Description: Competencies used for evaluations, roles, and training mappings.
Overview
- Columns: 20
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 4
- Indexes: 3
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
cpt_id | comp_id | integer | NO | Competency internal identifier, unique per tenant. | |
cpt_name | comp_denominazione | character varying(100) | NO | Competency name. | |
cpt_notes | comp_commento | text | NO | Competency notes or description. | |
cpt_competency_type_id | comp_compt_id | integer | NO | Reference to the competency type. | |
cpt_scale_f_min | comp_scalaf_minimo | numeric(3,0) | NO | Minimum value for scale F. | |
cpt_scale_f_max | comp_scalaf_massimo | numeric(3,0) | NO | Maximum value for scale F. | |
cpt_scale_f_step | comp_scalaf_incremento | numeric(6,2) | NO | Increment step for scale F. | |
cpt_scale_f_weight | comp_scalaf_peso | numeric(2,0) | NO | Weight for scale F. | |
cpt_scale_e_min | comp_scalae_minimo | numeric(3,0) | NO | Minimum value for scale E. | |
cpt_scale_e_max | comp_scalae_massimo | numeric(3,0) | NO | Maximum value for scale E. | |
cpt_scale_e_step | comp_scalae_incremento | numeric(6,2) | NO | Increment step for scale E. | |
cpt_scale_e_weight | comp_scalae_peso | numeric(2,0) | NO | Weight for scale E. | |
cpt_scale_v_min | comp_scalav_minimo | numeric(3,0) | NO | Minimum value for scale V. | |
cpt_scale_v_max | comp_scalav_massimo | numeric(3,0) | NO | Maximum value for scale V. | |
cpt_scale_v_step | comp_scalav_incremento | numeric(6,2) | NO | Increment step for scale V. | |
cpt_scale_v_weight | comp_scalav_peso | numeric(2,0) | NO | Weight for scale V. | |
tenant_id | tenant_id | integer | YES | Tenant identifier. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom fields in JSON format. |
_deleted | _deleted | boolean | YES | false | Soft delete flag. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_competencies_tenant_id | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
fk_competencies_type_id | cpt_competency_type_id, tenant_id | hr.competency_types | ctyp_id, tenant_id | RESTRICT | RESTRICT |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|---|---|---|
hr.performance_evaluation_form_items | fk_scval_comp_id | pefi_competence_id, tenant_id | cpt_id, tenant_id |
hr.person_competency_scores | fk_prcpsc_competency_id | pcs_competency_id, tenant_id | cpt_id, tenant_id |
hr.position_competency_requirements | fk_pcr_competency | pcr_competency_id, tenant_id | cpt_id, tenant_id |
hr.training_course_competencies | fk_training_course_competencies_competency | tcc_competency_id, tenant_id | cpt_id, tenant_id |
Constraints
- Primary key:
pk_competencies→id - Unique:
uk_competencies_cpt_id_tenant→cpt_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_competencies_tenant | NO | btree | tenant_id |
idx_competencies_tenant_cpt | NO | btree | tenant_id, cpt_id) WHERE (_deleted = false |
idx_competencies_tenant_type | NO | btree | tenant_id, cpt_competency_type_id) WHERE (_deleted = false |
Navigation
- Back to main index
- [Back to
hrindex]../)