pres.profora_assign
Schema: pres
English table: pres.profora_assign
Italian original table: pres.profora_assign
Description: Records for profora assign.
Overview
- Columns: 8
- Primary key: id
- Outgoing foreign keys: 3
- Incoming foreign keys: 0
- Indexes: 3
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Identifier of the related record. | |
orass_id | orass_id | integer | NO | Identifier of the related orass. | |
tenant_id | tenant_id | integer | NO | Identifier of the related tenant. | |
orass_dalla_data | orass_dalla_data | date | NO | Value of orass dalla data. | |
orass_alla_data | orass_alla_data | date | NO | Value of orass alla data. | |
orass_cod_profora | orass_cod_profora | character(4) | NO | ''::bpchar | Value of orass cod profora. |
orass_rap_id | orass_rap_id | integer | NO | 0 | Identifier of the related orass rap. |
orass_periodo | orass_periodo | daterange | YES | GENERATED: daterange(orass_dalla_data, orass_alla_data, '[]'::text) | Value of orass periodo. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_profora_assign_orass_cod_profora_to_profora | tenant_id, orass_cod_profora | pres.profora | tenant_id, cod_por | CASCADE | RESTRICT |
fk_profora_assign_orass_rap_id_to_rapporti | tenant_id, orass_rap_id | hr.employment_relationships | tenant_id, er_id | RESTRICT | CASCADE |
fk_profora_assign_tenant_id_to_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
profora_assign_pkey→id - Unique:
profora_assign_orass_id_key→tenant_id, orass_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_profora_assign_cod_profora | NO | btree | tenant_id, orass_cod_profora |
idx_profora_assign_orass_periodo | NO | gist | orass_periodo |
idx_profora_assign_rap_id | NO | btree | tenant_id, orass_rap_id |
Navigation
- Back to main index
- [Back to
presindex]../)