pres.employee_counter_assignments
Schema: pres
English table: pres.employee_counter_assignments
Italian original table: pres.dip_conta
Description: Junction table linking employees to their specific attendance and leave counters (e.g., Vacation, PTO, Overtime Bank).
Overview
- Columns: 5
- Primary key: id
- Outgoing foreign keys: 3
- Incoming foreign keys: 0
- Indexes: 1
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|
id | id | integer | NO | | Identifier of the related record. |
eca_id | dipc_id | integer | NO | | Unique internal identifier for the assignment. |
tenant_id | tenant_id | integer | NO | | Identifier of the related tenant. |
eca_employment_id | dipc_rap_id | integer | NO | 0 | Reference to the employee employment contract. |
eca_counter_definition_id | dipc_cnt_id | integer | NO | 0 | Reference to the counter type definition (from tab_contatori). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk_dip_conta_dipc_rap_id_to_rapporti | tenant_id, eca_employment_id | hr.employment_relationships | tenant_id, er_id | RESTRICT | CASCADE |
fk_eca_counter_definition | tenant_id, eca_counter_definition_id | pres.attendance_counter_definitions | tenant_id, acd_counter_id | CASCADE | CASCADE |
fk_eca_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_employee_counter_assignments → id
- Unique:
c_uk_eca_employment_counter_tenant → tenant_id, eca_employment_id, eca_counter_definition_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx_eca_counter_definition_lookup | NO | btree | tenant_id, eca_counter_definition_id |
Navigation