pres.shift_planning_sort_order
Schema: pres
English table: pres.shift_planning_sort_order
Italian original table: pres.cartellino_turni_ordinamento
Description: Storage for custom display sorting of employees within the shift planning interface.
Overview
- Columns: 5
- Primary key: id
- Outgoing foreign keys: 2
- 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. |
spso_id | carto_id | integer | NO | | Unique identifier for the sorting record. |
tenant_id | tenant_id | integer | NO | | Identifier of the related tenant. |
spso_employment_id | carto_rap_id | integer | YES | | Reference to the employee employment contract. |
spso_sort_index | carto_ordinamento | integer | YES | | Integer value defining the display sequence (lower is first). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk_cartellino_turni_ordinamento_carto_rap_id_to_rapporti | tenant_id, spso_employment_id | hr.employment_relationships | tenant_id, er_id | RESTRICT | CASCADE |
fk_spso_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_shift_planning_sort_order → id
- Unique:
c_uk_spso_id_tenant → tenant_id, spso_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx_spso_employment_lookup | NO | btree | tenant_id, spso_employment_id |
Navigation