hr.contract_level_job_links

Schema: hr
English table: hr.contract_level_job_links
Italian original table:
Description: Association table linking contract levels to job roles (mansioni) within a tenant.

Overview

• Columns: 7
• Primary key: id
• Outgoing foreign keys: 5
• Incoming foreign keys: 0
• Indexes: 4

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	``	integer	NO		Internal surrogate primary key.
link_code	``	integer	NO		Business identifier of the association record, unique per tenant.
contract_level_code	``	integer	NO		Reference to the contract level (business code), unique per tenant.
job_code	``	integer	NO		Reference to the job role (mansione) business code, unique per tenant.
tenant_id	``	integer	YES		Tenant identifier for multi-tenant partitioning.
colcustom	``	jsonb	YES	'{}'::jsonb	Custom fields in JSON format.
_deleted	``	boolean	YES	false	Soft-delete flag. True means the record is logically deleted.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_cljl_contract_level	contract_level_code, tenant_id	hr.agreement_levels	al_code, tenant_id	RESTRICT	RESTRICT
fk_cljl_job	job_code, tenant_id	hr.job_roles	jr_code_id, tenant_id	RESTRICT	RESTRICT
fk_conl_id	contract_level_code, tenant_id	hr.agreement_levels	al_code, tenant_id	RESTRICT	RESTRICT
fk_man_id	job_code, tenant_id	hr.job_roles	jr_code_id, tenant_id	RESTRICT	RESTRICT
fk_tenant_id	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: contract_level_job_links_pkey → id
• Unique: uk_cljl_link_code_tenant → link_code, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_cljl_tenant	NO	btree	tenant_id
idx_cljl_tenant_contract_level	NO	btree	tenant_id, contract_level_code) WHERE (_deleted = false
idx_cljl_tenant_job	NO	btree	tenant_id, job_code) WHERE (_deleted = false
idx_cljl_tenant_link_code	NO	btree	tenant_id, link_code) WHERE (_deleted = false

Navigation

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