hr.deadline_types

Schema: hr
English table: hr.deadline_types
Italian original table: hr.scadenze
Description: Catalog of deadline types and scheduling rules (notice, repetition and shifting) within the tenant.

Overview

• Columns: 16
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 0
• Indexes: 3

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
deadline_type_id	scad_id	integer	NO		Tenant-scoped deadline type identifier.
name	scad_denominazione	character varying(60)	NO		Deadline type name.
description	scad_descrizione	text	NO		Deadline type description.
notice_days	scad_gg_preavviso	numeric(3,0)	NO		Number of days of notice before the deadline.
fixed_date	scad_data_fissa	date	NO		Fixed date associated with the deadline type, if applicable.
category_code	scad_tipologia	character varying(3)	NO		Deadline category code.
reference_code	scad_riferimento	character varying(3)	NO		Reference code used to calculate or classify the deadline.
repeat_count	scad_num_ripetizioni	numeric(4,0)	NO		Default number of repetitions for the deadline type.
shift_days	scad_sposta_giorno	numeric(2,0)	NO		Number of days to shift the calculated deadline.
shift_direction_code	scad_sposta_prec_succ	numeric(2,0)	NO		Shift direction code (e.g., previous/next) used with shift_days.
deadline_period_label	scad_periodo_scadenza	character varying(30)	NO		Text label describing the deadline period.
activity_id	scad_att_id	integer	NO		Referenced activity identifier associated with the deadline type.
tenant_id	tenant_id	integer	YES		Tenant identifier.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom fields in JSON format.
_deleted	_deleted	boolean	YES	false	Technical soft delete flag.

Relationships

Outgoing foreign keys

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

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_deadline_types → id
• Unique: uk_deadline_types_deadline_type_id → deadline_type_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_dlty_tenant	NO	btree	tenant_id
idx_dlty_tenant_activity	NO	btree	tenant_id, activity_id) WHERE (_deleted = false
idx_dlty_tenant_type_id	NO	btree	tenant_id, deadline_type_id) WHERE (_deleted = false

Navigation

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