Schema: pres
English table: pres.counter_groups
Italian original table: pres.tab_cont_grp
Description: Definitions of counter groups used to categorize different types of attendance metrics (e.g., Leave, Overtime, Presence).
Overview
- Columns: 6
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 0
- Indexes: 1
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|
id | id | integer | NO | | Primary Key. |
cg_group_id | cntg_id | integer | NO | | Internal unique identifier for the counter group. |
tenant_id | tenant_id | integer | NO | | Tenant identifier for data isolation. |
cg_description | cntg_descrizione | character(40) | NO | ''::bpchar | Human-readable name of the counter group. |
cg_notes | cntg_commento | text | NO | ''::text | Extended description or technical notes about the group. |
cg_sort_order | cntg_order | numeric(3,0) | NO | 0 | Numerical value used to determine the display order in reports or UI. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk_cg_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_counter_groups → id
- Unique:
c_uk_cg_tenant_group_id → tenant_id, cg_group_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx_cg_tenant_group_id | NO | btree | tenant_id, cg_group_id |
Navigation