hr.agreement_qualifications
Schema: hr
English table: hr.agreement_qualifications
Italian original table: hr.con_qualifiche
Description: Legal qualifications (Operaio, Impiegato, etc.) defined within a Collective Labor Agreement.
Overview
- Columns: 11
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 3
- Indexes: 3
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Internal surrogate primary key. | |
aq_code | conq_id | integer | NO | Business identifier of the contract qualification, unique per tenant. | |
aq_agreement_code | conq_con_id | integer | NO | Reference to the employment contract definition (business code), unique per tenant. | |
aq_description | conq_descrizione | character varying(50) | NO | Description/label of the contract qualification. | |
aq_inps_code | conq_codice_inps | character varying(5) | NO | Official INPS classification code for Italian labor reporting. | |
aq_sort_order | conq_order | numeric(2,0) | NO | Ordering value used to sort qualifications within the same contract. | |
aq_sync_code | conq_code_syncro | character varying(10) | NO | External synchronization code for integrations. | |
aq_meridiana_code | conq_codice_meridiana | character varying(4) | NO | Meridiana classification code associated with this contract qualification. | |
tenant_id | tenant_id | integer | YES | Tenant identifier for multi-tenant partitioning. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom fields in JSON format. |
_deleted | _deleted | boolean | YES | false | Soft-delete flag. True means the record is logically deleted. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_aq_collective_agreement | aq_agreement_code, tenant_id | hr.collective_agreements | ca_code, tenant_id | RESTRICT | RESTRICT |
fk_aq_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|---|---|---|
hr.agreement_levels | fk_al_agreement_qualification | al_agreement_qualification_code, tenant_id | aq_code, tenant_id |
hr.employment_relationship_details | fk_erd_job_grade_id | erd_job_grade_id, tenant_id | aq_code, tenant_id |
hr.medical_exam_type_parameters | fk_metp_job_qualification_id | metp_job_qualification_id, tenant_id | aq_code, tenant_id |
Constraints
- Primary key:
pk_aq→id - Unique:
uk_aq_code_tenant→aq_code, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_aq_agreement_tenant | NO | btree | tenant_id, aq_agreement_code) WHERE (_deleted = false |
idx_aq_code_tenant | NO | btree | tenant_id, aq_code) WHERE (_deleted = false |
idx_aq_tenant | NO | btree | tenant_id |
Navigation
- Back to main index
- [Back to
hrindex]../)