pres.weekly_shift_schema_days
Schema: pres
English table: pres.weekly_shift_schema_days
Italian original table: pres.profora_settimane
Description: Detailed daily breakdown of a weekly shift schema. Defines which specific day of the cycle a date represents.
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 | Primary Key. | |
wssd_day_id | proset_id | integer | NO | Internal unique identifier for the schema day record. | |
tenant_id | tenant_id | integer | NO | Tenant identifier for data isolation. | |
wssd_date | proset_data | date | NO | The specific calendar date within the schema detail. | |
wssd_cycle_week_number | proset_settimana | numeric(2,0) | YES | 1 | The week number within the rotation cycle (e.g., week 1 of 4). |
wssd_is_forced | proset_forzato | boolean | YES | false | Boolean flag indicating if this day was manually overridden/forced. |
wssd_schema_id | proset_rap_id | integer | NO | 0 | Foreign key to weekly_shift_schemas.id (or wss_schema_id). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_profora_settimane_proset_rap_id_to_rapporti | tenant_id, wssd_schema_id | hr.employment_relationships | tenant_id, er_id | RESTRICT | CASCADE |
fk_wssd_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_weekly_shift_schema_days→id - Unique:
c_uk_wssd_tenant_date_schema→tenant_id, wssd_date, wssd_schema_id - Unique:
c_uk_wssd_tenant_day→tenant_id, wssd_day_id
Indexes
No indexes detected.
Navigation
- Back to main index
- [Back to
presindex]../)