hr.x_report_columns

Schema: hr
English table: hr.x_report_columns
Italian original table: hr.x_reports_column
Description: Configuration of individual columns for system reports (Service table).

Overview

• Columns: 12
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 0
• Indexes: 5

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
xrc_id	xrepco_id	integer	NO		Identifier of the related xrc record.
xrc_report_id	xrepco_xrep_id	integer	NO		Reference to the parent report in x_reports.
xrc_field_id	xrepco_fld_id	integer	NO		Identifier of the related xrc field record.
xrc_position	xrepco_position	numeric(2,0)	NO		Xrc position.
xrc_field_type	xrepco_type_field	numeric(1,0)	NO		Xrc field type.
xrc_function_id	xrepco_xfunag_id	integer	NO		Identifier of the related xrc function record.
xrc_alias	xrepco_alias	character varying(50)	NO		The display name or SQL alias for the column.
xrc_chart_axis	xrepco_position_xy	numeric(1,0)	NO		Xrc chart axis.
xrc_range	xrepco_range	character varying(50)	NO		Text value.
xrc_params	xrepco_param1	text	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_report_columns → id
• Unique: uk_xrc_id_tenant → xrc_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_xrc_field_tenant	NO	btree	tenant_id, xrc_field_id
idx_xrc_function_tenant	NO	btree	tenant_id, xrc_function_id
idx_xrc_id_tenant	NO	btree	tenant_id, xrc_id
idx_xrc_report_tenant	NO	btree	tenant_id, xrc_report_id
idx_xrc_tenant	NO	btree	tenant_id

Navigation

• Back to main index
• [Back to hr index]../)