Schema: hr
English table: hr._forms
Italian original table: hr._forms
Description: Configuration table that defines application forms and their grid layout settings.
Overview
- Columns: 6
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 1
- Indexes: 3
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|
id | id | integer | NO | | Primary key. |
frm_form_id | frm_id | integer | NO | | Form identifier (unique per tenant). |
frm_form_name | frm_name | character varying(20) | NO | | Form name. |
frm_horizontal_grid | frm_h_grid | numeric(2,0) | NO | | Horizontal grid size used by the form layout. |
frm_vertical_grid | frm_v_grid | numeric(2,0) | NO | | Vertical grid size used by the form layout. |
tenant_id | tenant_id | integer | YES | | Tenant identifier. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk__forms_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|
hr._forms_link | fk__forms_link_form | frml_form_id, tenant_id | frm_form_id, tenant_id |
Constraints
- Primary key:
pk__forms → id
- Unique:
uk__forms_tenant_form_id → frm_form_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx_frm_tenant | NO | btree | tenant_id |
idx_frm_tenant_form_id | NO | btree | tenant_id, frm_form_id |
idx_frm_tenant_name | NO | btree | tenant_id, frm_form_name |
Navigation