pres.daily_shift_planning
Schema: pres
English table: pres.daily_shift_planning
Italian original table: pres.cartellino_turni
Description: Planned daily shifts and schedule assignments for employees.
Overview
- Columns: 10
- 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. | |
dsp_id | cart_id | integer | NO | Unique identifier for the shift planning record. | |
tenant_id | tenant_id | integer | NO | Identifier of the related tenant. | |
dsp_employment_id | cart_rap_id | integer | YES | Reference to the employee employment contract. | |
dsp_date_str | cart_data | character varying(8) | YES | Reference date in string format (typically YYYYMMDD). | |
dsp_shift_code | cart_cod_ora | character varying(4) | YES | The code of the shift scheduled for this day. | |
dsp_free_schedule_details | cart_orari_liberi | character varying(50) | YES | Custom or non-standard schedule details for free-form planning. | |
dsp_reason_code | cart_causale | character varying(4) | YES | Reason code for special shift assignments (e.g., on-call, smart working). | |
dsp_reason_clockings_str | cart_tim_causale | character varying(200) | YES | Value of dsp reason clockings str. | |
dsp_week_number | cart_settimana | integer | YES | Numeric value for dsp week number. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_cartellino_turni_cart_rap_id_to_rapporti | tenant_id, dsp_employment_id | hr.employment_relationships | tenant_id, er_id | RESTRICT | CASCADE |
fk_dsp_shift_type | tenant_id, dsp_shift_code | pres.shift_definitions | tenant_id, shd_code | CASCADE | RESTRICT |
fk_dsp_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_daily_shift_planning→id - Unique:
c_uk_dsp_employment_date_tenant→tenant_id, dsp_employment_id, dsp_date_str - Unique:
c_uk_dsp_id_tenant→tenant_id, dsp_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_dsp_date_lookup | NO | btree | tenant_id, dsp_date_str |
Navigation
- Back to main index
- [Back to
presindex]../)