Schema: hr
English table: hr._control_functions
Italian original table: hr._control_function
Description: Tenant-scoped control functions used for application validation logic.
Overview
- Columns: 8
- 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. |
ctf_function_id | ctrfun_id | integer | NO | | Business identifier of the control function. |
ctf_function_name | ctrfun_name_fn | character varying(100) | NO | | Database function name executed for control or validation. |
ctf_arg1 | ctrfn_arg1 | character varying(50) | NO | | First argument passed to the control function. |
ctf_arg2 | ctrfn_arg2 | character varying(50) | NO | | Second argument passed to the control function. |
ctf_arg3 | ctrfn_arg3 | character varying(50) | NO | | Third argument passed to the control function. |
ctf_error_message | ctrfn_message_error | character varying(200) | NO | | Error message returned when the control function validation fails. |
tenant_id | tenant_id | integer | YES | | Tenant identifier. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk__control_functions_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk__control_functions → id
- Unique:
uk_ctf_function_id_tenant → ctf_function_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx_ctf_tenant | NO | btree | tenant_id |
Navigation