hr.positions

Schema: hr
English table: hr.positions
Italian original table: hr.ruoli
Description: Master data for internal organizational positions and functional roles, independent of legal/CCNL job roles.

Overview

• Columns: 7
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 5
• Indexes: 2

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
pos_code_id	ru_id	integer	NO		Business identifier of the position (unique per tenant).
pos_title	ru_descrizione	character varying(100)	NO		Functional title or short description of the position.
pos_notes	ru_commento	text	NO		Extended notes or internal description regarding the position.
tenant_id	tenant_id	integer	YES		Tenant identifier for multi-tenant isolation.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom fields in JSON format.
_deleted	_deleted	boolean	YES	false	Soft-delete flag.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_pos_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
hr.organization_units	fk_org_role_id	ou_role_id, tenant_id	pos_code_id, tenant_id
hr.performance_evaluation_forms	fk_scva_role_id	pef_position_id, tenant_id	pos_code_id, tenant_id
hr.position_competency_requirements	fk_pcr_position	pcr_position_code_id, tenant_id	pos_code_id, tenant_id
hr.position_equipment_requirements	fk_rudo_role_id	per_position_id, tenant_id	pos_code_id, tenant_id
hr.rapporti_ruoli	fk_rapru_role_id	rapru_ru_id, tenant_id	pos_code_id, tenant_id

Constraints

• Primary key: pk_pos → id
• Unique: uk_pos_code_tenant → pos_code_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_pos_code_tenant	NO	btree	tenant_id, pos_code_id) WHERE (_deleted = false
idx_pos_tenant	NO	btree	tenant_id

Navigation

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