hr.rapporti_ruoli
Schema: hr
English table: hr.rapporti_ruoli
Italian original table: hr.rapporti_ruoli
Description: Records for rapporti ruoli.
Overview
- Columns: 11
- 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. | |
rapru_id | rapru_id | integer | NO | Identifier of the related rapru record. | |
rapru_rap_id | rapru_rap_id | integer | NO | Identifier of the related rapru rap record. | |
rapru_ru_id | rapru_ru_id | integer | NO | Identifier of the related rapru ru record. | |
rapru_percetage | rapru_percetage | numeric(3,0) | NO | Rapru percetage. | |
rapru_dal | rapru_dal | date | NO | Rapru dal. | |
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. |
rapru_al | rapru_al | date | YES | Rapru al. | |
rapru_periodo | rapru_periodo | daterange | YES | GENERATED: daterange(rapru_dal, rapru_al, '[]'::text) | Rapru periodo. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_rapru_rap_id | rapru_rap_id, tenant_id | hr.employment_relationships | er_id, tenant_id | RESTRICT | CASCADE |
fk_rapru_role_id | rapru_ru_id, tenant_id | hr.positions | pos_code_id, tenant_id | RESTRICT | RESTRICT |
fk_tenant_id | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
rapporti_ruoli_pkey→id - Unique:
k_rapru_id_unique→rapru_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_rapporti_ruoli_rapru_id_tenant | NO | btree | tenant_id, rapru_id) WHERE (_deleted = false |
idx_rapporti_ruoli_rapru_rap_id_tenant | NO | btree | tenant_id, rapru_rap_id) WHERE (_deleted = false |
idx_rapporti_ruoli_rapru_ru_id_tenant | NO | btree | tenant_id, rapru_ru_id) WHERE (_deleted = false |
idx_rapporti_ruoli_tenant | NO | btree | tenant_id |
idx_rapporti_ruoli_tenant_rapru_periodo_gist | NO | gist | tenant_id, rapru_periodo) WHERE (_deleted = false |
idx_rapporti_ruoli_tenant_rapru_periodo_rap_gist | NO | gist | tenant_id, rapru_rap_id, rapru_periodo) WHERE (_deleted = false |
Navigation
- Back to main index
- [Back to
hrindex]../)