hr.employment_relationship_deadlines

Schema: hr
English table: hr.employment_relationship_deadlines
Italian original table:
Description: Employment relationship deadlines / due dates. Stores event date and the recalculated/new due date for an employment relationship (multi-tenant).

Overview

• Columns: 8
• Primary key: id
• Outgoing foreign keys: 2
• Incoming foreign keys: 0
• Indexes: 4

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	``	integer	NO		Surrogate primary key.
erdl_id	``	integer	NO		Logical deadline identifier (unique per tenant).
erdl_er_id	``	integer	NO		Employment relationship identifier. FK to hr.employment_relationships(er_id, tenant_id).
erdl_event_date	``	date	NO		Event date that triggers the deadline (source date).
erdl_new_due_date	``	date	NO		New due date calculated/generated from the event date.
tenant_id	``	integer	YES		Tenant identifier for data isolation.
colcustom	``	jsonb	YES	'{}'::jsonb	Custom fields (JSON).
_deleted	``	boolean	YES	false	Technical soft-delete flag.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_erdl_er_id	erdl_er_id, tenant_id	hr.employment_relationships	er_id, tenant_id	RESTRICT	CASCADE
fk_erdl_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_employment_relationship_deadlines → id
• Unique: uk_erdl_id_tenant → erdl_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_employment_relationship_deadlines_tenant	NO	btree	tenant_id
idx_erdl_er_id_tenant	NO	btree	tenant_id, erdl_er_id) WHERE (_deleted = false
idx_erdl_id_tenant	NO	btree	tenant_id, erdl_id) WHERE (_deleted = false
idx_erdl_new_due_date_tenant	NO	btree	tenant_id, erdl_new_due_date) WHERE (_deleted = false

Navigation

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