hr.person_benefits
Schema: hr
English table: hr.person_benefits
Italian original table: hr.ana_benefit
Description: Records for person benefits.
Overview
- Columns: 10
- Primary key: id
- Outgoing foreign keys: 3
- Incoming foreign keys: 0
- Indexes: 6
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
pbn_id | anaben_id | integer | NO | Identifier of the related pbn record. | |
pbn_employment_relationship_id | anaben_rap_id | integer | NO | Identifier of the related pbn employment relationship record. | |
pbn_start_date | anaben_date_start | date | NO | Date associated with the record. | |
pbn_end_date | anaben_date_end | date | NO | Date associated with the record. | |
pbn_benefit_id | anaben_ben_id | integer | NO | Identifier of the related pbn benefit record. | |
tenant_id | tenant_id | integer | YES | Tenant identifier for data isolation. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | JSON payload containing additional attributes. |
_deleted | _deleted | boolean | YES | false | Flag indicating whether the record is soft-deleted. |
pbn_period | anaben_periodo | daterange | YES | GENERATED: daterange(pbn_start_date, pbn_end_date, '[]'::text) | Pbn period. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_pbn_benefit | pbn_benefit_id, tenant_id | hr.benefits | bft_id, tenant_id | RESTRICT | RESTRICT |
fk_pbn_employment_relationship | pbn_employment_relationship_id, tenant_id | hr.employment_relationships | er_id, tenant_id | RESTRICT | CASCADE |
fk_person_benefits_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
ana_benefit_pkey→id - Unique:
k_anaben_id_unique→pbn_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_ana_benefit_anaben_ben_id_tenant | NO | btree | tenant_id, pbn_benefit_id) WHERE (_deleted = false |
idx_ana_benefit_anaben_id_tenant | NO | btree | tenant_id, pbn_id) WHERE (_deleted = false |
idx_ana_benefit_anaben_rap_id_tenant | NO | btree | tenant_id, pbn_employment_relationship_id) WHERE (_deleted = false |
idx_ana_benefit_tenant | NO | btree | tenant_id |
idx_pbn_tenant_period_gist | NO | gist | tenant_id, pbn_period) WHERE (_deleted = false |
idx_pbn_tenant_rap_period_gist | NO | gist | tenant_id, pbn_employment_relationship_id, pbn_period) WHERE (_deleted = false |
Navigation
- Back to main index
- [Back to
hrindex]../)