pres.daily_attendance_hours_distribution
Schema: pres
English table: pres.daily_attendance_hours_distribution
Italian original table: pres.cartellino_ore
Description: Detailed breakdown of daily attendance hours into categories, activities, or pay-types.
Overview
- Columns: 7
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 0
- Indexes: 0
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Identifier of the related record. | |
dahd_id | caro_id | integer | NO | Unique internal identifier for the distribution record. | |
tenant_id | tenant_id | integer | NO | Identifier of the related tenant. | |
dahd_daily_attendance_id | caro_car_id | integer | YES | Reference to the parent daily attendance detail record. | |
dahd_category_id | caro_id_tab | integer | YES | Reference to the specific category or activity table (e.g., project, task, or wage component). | |
dahd_hours | caro_ore | integer | YES | Amount of regular hours assigned to this specific category. | |
dahd_overtime_hours | caro_ore_strao | integer | YES | Amount of overtime hours assigned to this specific category. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_dahd_daily_attendance | tenant_id, dahd_daily_attendance_id | pres.daily_attendance_details | tenant_id, dad_id | CASCADE | CASCADE |
fk_dahd_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_daily_attendance_hours_distribution→id - Unique:
c_uk_dahd_daily_id_tenant→tenant_id, dahd_daily_attendance_id - Unique:
c_uk_dahd_id_tenant→tenant_id, dahd_id
Indexes
No indexes detected.
Navigation
- Back to main index
- [Back to
presindex]../)