Schema: pres
English table: pres.employee_badges
Italian original table: pres.badge
Description: Assignment table linking physical badge numbers to employee employment records with temporal validity ranges.
Overview
- Columns: 8
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 0
- Indexes: 3
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|
id | id | integer | NO | | Identifier of the related record. |
emb_id | badge_id | integer | NO | | Unique identifier for the badge assignment. |
tenant_id | tenant_id | integer | NO | | Identifier of the related tenant. |
emb_employment_id | badge_rap_id | integer | NO | 0 | Identifier of the related emb employment. |
emb_badge_number | badge_cod_badge | character(6) | NO | ''::bpchar | The physical or alphanumeric code of the badge. |
emb_valid_from | badge_dal | date | NO | | Value of emb valid from. |
emb_valid_to | badge_al | date | NO | | Value of emb valid to. |
emb_validity_range | badge_periodo | daterange | YES | GENERATED: daterange(emb_valid_from, emb_valid_to, '[]'::text) | Temporal range (daterange) during which the badge is assigned to the employee. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk_badge_badge_rap_id_to_rapporti | tenant_id, emb_employment_id | hr.employment_relationships | tenant_id, er_id | RESTRICT | CASCADE |
fk_emb_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_employee_badges → id
- Unique:
badge_badge_id_key → tenant_id, emb_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx_emb_badge_number_lookup | NO | btree | tenant_id, emb_badge_number |
idx_emb_employment_lookup | NO | btree | tenant_id, emb_employment_id |
idx_emb_validity_range_gist | NO | gist | emb_validity_range |
Navigation