pres.attendance_configuration
Schema: pres
English table: pres.attendance_configuration
Italian original table:
Description: Key-value store for attendance module settings and calculation engine parameters.
Overview
- Columns: 6
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 0
- Indexes: 0
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | `` | integer | NO | Internal surrogate primary key. | |
aconf_config_id | `` | integer | NO | Unique business identifier for the configuration record. | |
tenant_id | `` | integer | NO | Tenant identifier for multi-tenancy isolation. | |
aconf_key | `` | character(20) | NO | ''::bpchar | The unique name/key of the configuration variable (e.g., "MAX_OVERTIME"). |
aconf_data_type | `` | character(1) | YES | ''::bpchar | Type of data stored in the value field (S=String, N=Numeric, B=Boolean). |
aconf_value | `` | text | YES | ''::text | The actual value of the configuration setting, stored as text. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_aconf_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_attendance_configuration→id - Unique:
c_uk_aconf_tenant_config_id→tenant_id, aconf_config_id - Unique:
c_uk_aconf_tenant_key→tenant_id, aconf_key
Indexes
No indexes detected.
Navigation
- Back to main index
- [Back to
presindex]../)