hr.languages
Schema: hr
English table: hr.languages
Italian original table: hr.lingue
Description: System-wide language registry used for UI localization, templates, and reporting.
Overview
- Columns: 7
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 8
- Indexes: 2
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Internal unique identifier (surrogate key). | |
language_code_id | ling_id | integer | NO | Functional language identifier, unique within the tenant (e.g., ISO-like code). | |
name | ling_denominazione | character varying(60) | NO | Display name of the language (e.g., English, Italiano). | |
notes | ling_note | text | NO | General notes or descriptions about the language entry. | |
tenant_id | tenant_id | integer | YES | Tenant identifier for data isolation. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom metadata fields in JSON format. |
_deleted | _deleted | boolean | YES | false | Technical flag for soft delete. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_languages_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|---|---|---|
hr._data_area_attributes | fk__data_area_attributes_language | daa_language_id, tenant_id | language_code_id, tenant_id |
hr._email_templates | fk__email_templates_language | emt_language_id, tenant_id | language_code_id, tenant_id |
hr._field_attributes | fk__field_attributes_language | fad_language_id, tenant_id | language_code_id, tenant_id |
hr.user_session | fk_user_session_language | us_language_id, tenant_id | language_code_id, tenant_id |
hr.x_payslip_body_items | fk_xpbi_language | xpbi_language_id, tenant_id | language_code_id, tenant_id |
hr.x_salary_costs_settings | fk_xsc_language | xsc_language_id, tenant_id | language_code_id, tenant_id |
hr.x_salary_elements_settings | fk_xse_language | xse_language_id, tenant_id | language_code_id, tenant_id |
hr.x_salary_progressives_settings | fk_xsp_language | xsp_language_id, tenant_id | language_code_id, tenant_id |
Constraints
- Primary key:
pk_languages→id - Unique:
uk_languages_code_tenant→language_code_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_lang_code_tenant | NO | btree | tenant_id, language_code_id) WHERE (_deleted = false |
idx_languages_tenant | NO | btree | tenant_id |
Navigation
- Back to main index
- [Back to
hrindex]../)