hr.special_regulations

Schema: hr
English table: hr.special_regulations
Italian original table: hr.leggi_speciali
Description: Registry of special labor laws, employment regulations, or tax incentive schemes.

Overview

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

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Internal unique identifier (surrogate key).
regulation_code_id	legspe_id	integer	NO		Functional regulation identifier, unique within the tenant.
title	legspe_title	character varying(100)	NO		Short title or name of the regulation.
description	legspe_description	character varying(200)	NO		Detailed description of the regulation or law.
tenant_id	tenant_id	integer	YES		Tenant identifier for data isolation.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom metadata fields in JSON format.
_deleted	_deleted	boolean	YES	false	Technical flag for soft delete.

Relationships

Outgoing foreign keys

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

Referenced by

From table	Foreign key	Source columns	Target columns
hr.employment_special_regulation_assignments	fk_esra_special_regulation	esra_special_regulation_id, tenant_id	regulation_code_id, tenant_id

Constraints

• Primary key: pk_special_regulations → id
• Unique: uk_special_regulations_code_tenant → regulation_code_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_special_regulations_tenant	NO	btree	tenant_id
idx_sr_code_tenant	NO	btree	tenant_id, regulation_code_id) WHERE (_deleted = false

Navigation

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