Schema: hr
English table: hr.x_reports
Italian original table: hr.x_reports
Description: Master table for system reports configuration, including SQL logic and chart settings (Service table).
Overview
- Columns: 19
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 0
- Indexes: 3
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|
id | id | integer | NO | | Surrogate primary key. |
xr_id | xrep_id | integer | NO | | Identifier of the related xr record. |
xr_title | xrep_title | character varying(100) | NO | | Display name for xr. |
xr_type | xrep_type | numeric(1,0) | NO | | Xr type. |
xr_use_variable | xrep_use_variable | boolean | NO | | Boolean flag. |
xr_variable | xrep_variable | character varying(50) | NO | | Text value. |
xr_notes | xrep_note | text | NO | | Free-form notes. |
xr_group_id | xrep_grrep_id | integer | NO | | Reference to the report category/group. |
xr_start_date | xrep_date_start | date | NO | | Date associated with the record. |
xr_end_date | xrep_date_end | date | NO | | Date associated with the record. |
xr_grouping_count | xrep_numero_raggruppamenti | numeric(1,0) | NO | | Xr grouping count. |
xr_output_type | xrep_tipo_output | character varying(10) | NO | | Text value. |
xr_list_id | xrep_lista_id | character varying(10) | NO | | Identifier of the related xr list record. |
xr_force_report_date | xrep_forza_data_report | boolean | NO | | Date associated with the record. |
xr_chart_type | xrep_type_chart | numeric(2,0) | NO | | Xr chart type. |
xr_use_custom_sql | xrep_use_custom_sql | boolean | NO | | Boolean flag. |
xr_custom_sql | xrep_custom_sql | text | NO | | Direct SQL query used when xr_use_custom_sql is true. |
xr_custom_chart_columns | xrep_custom_col_chart | character varying(100) | NO | | Text value. |
tenant_id | tenant_id | integer | YES | | Tenant identifier for data isolation. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk_tenant_id | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_x_reports → id
- Unique:
uk_xr_id_tenant → xr_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx_xr_group_tenant | NO | btree | tenant_id, xr_group_id |
idx_xr_id_tenant | NO | btree | tenant_id, xr_id |
idx_xr_tenant | NO | btree | tenant_id |
Navigation