pres.attendance_reason_cascades
Schema: pres
English table: pres.attendance_reason_cascades
Italian original table: pres.tabgiu_collegate
Description: Defines cascading rules where a parent attendance reason triggers the calculation of a child reason.
Overview
- Columns: 10
- Primary key: id
- Outgoing foreign keys: 3
- Incoming foreign keys: 0
- Indexes: 0
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Primary Key surrogate. | |
arc_cascade_id | giu_id | integer | NO | Unique internal identifier for the cascade rule. | |
tenant_id | tenant_id | integer | NO | Tenant identifier for multi-tenancy isolation. | |
arc_parent_reason_code | cod_giu | character(4) | NO | ''::bpchar | The source reason code that triggers the cascade. |
arc_child_reason_code | cod_giu_collegato | character(4) | NO | ''::bpchar | The target reason code generated by the cascade. |
arc_value_type | giu_value_type | numeric(1,0) | NO | 0 | Type of value to be generated (e.g., hours, fixed, percentage). |
arc_is_manual_override | giu_forzato | boolean | NO | false | Flag to force the child value even if already present. |
arc_calculation_expression | giu_expr | character(100) | NO | ''::bpchar | Formula used to derive the child value from the parent. |
arc_math_operation | giu_operazione | smallint | NO | 1 | ID of the mathematical operation to apply (e.g., 1 for addition). |
arc_keep_same_time_slot | giu_stessa_fascia_oraria | boolean | NO | false | If true, the child reason is assigned to the exact same time window as the parent. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_arc_child_reason | tenant_id, arc_child_reason_code | pres.attendance_reasons | tenant_id, ar_code | CASCADE | RESTRICT |
fk_arc_parent_reason | tenant_id, arc_parent_reason_code | pres.attendance_reasons | tenant_id, ar_code | CASCADE | CASCADE |
fk_arc_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_attendance_reason_cascades→id - Unique:
c_uk_arc_tenant_cascade_id→tenant_id, arc_cascade_id - Unique:
c_uk_arc_tenant_parent_code→tenant_id, arc_parent_reason_code
Indexes
No indexes detected.
Navigation
- Back to main index
- [Back to
presindex]../)