hr.person_language_certifications
Schema: hr
English table: hr.person_language_certifications
Italian original table: hr.ana_lingue
Description: Language certifications associated with a person, including level, certification type and date, within the tenant.
Overview
- Columns: 10
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 0
- Indexes: 5
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|
id | id | integer | NO | | Surrogate primary key. |
person_language_certification_id | analing_id | integer | NO | | Tenant-scoped language certification identifier. |
person_id | analing_ana_id | integer | NO | | Referenced person identifier (tenant-scoped). |
language_level_id | analing_lingl_id | integer | NO | | Referenced language/level identifier (tenant-scoped). |
certification_type_code | analing_tipo_certificazione | numeric(1,0) | NO | | Certification type code. |
training_course_id | analing_cor_id | integer | NO | | Referenced training course identifier (tenant-scoped), if applicable. |
certified_on | analing_data | date | NO | | Certification date. |
tenant_id | tenant_id | integer | YES | | Tenant identifier. |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom fields in JSON format. |
_deleted | _deleted | boolean | YES | false | Technical soft delete flag. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk_plcert_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_person_language_certifications → id
- Unique:
uk_plcert_certification_id → person_language_certification_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx_plcert_tenant | NO | btree | tenant_id |
idx_plcert_tenant_cert_id | NO | btree | tenant_id, person_language_certification_id) WHERE (_deleted = false |
idx_plcert_tenant_course | NO | btree | tenant_id, training_course_id) WHERE (_deleted = false |
idx_plcert_tenant_lang_level | NO | btree | tenant_id, language_level_id) WHERE (_deleted = false |
idx_plcert_tenant_person | NO | btree | tenant_id, person_id) WHERE (_deleted = false |
Navigation