hr.person_children

Schema: hr
English table: hr.person_children
Italian original table: hr.ana_figli
Description: Children records associated with a person, including personal data and validity period, within the tenant.

Overview

• Columns: 23
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 0
• Indexes: 6

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
person_child_id	anafi_id	integer	NO		Tenant-scoped child record identifier.
person_id	anafi_ana_id	integer	NO		Referenced person identifier (tenant-scoped).
family_relation_type_id	anafi_fam_id	integer	NO		Family relation/type identifier associated with the child record.
last_name	anafi_cognome	character varying(30)	NO		Child last name.
first_name	anafi_nome	character varying(20)	NO		Child first name.
valid_from	anafi_data_inizio	date	NO		Start date of the record validity.
valid_to	anafi_data_fine	date	NO		End date of the record validity.
birth_municipality	anafi_comune_nascita	character varying(30)	NO		Municipality of birth.
birth_province_code	anafi_prov_nascita	character varying(2)	NO		Province code of birth.
tax_code	anafi_codice_fiscale	character varying(16)	NO		Italian tax code (codice fiscale).
tax_dependent_flag	anafi_a_carico	numeric(3,0)	NO		Numeric flag indicating whether the child is a tax dependent.
is_disabled	anafi_disabile	boolean	NO		Indicates whether the child has a disability.
disability_percentage	anafi_perc_disabilita	numeric(3,0)	NO		Disability percentage.
has_l104_rights	anafi_diritto_l104	boolean	NO		Indicates entitlement under Italian Law 104.
gender_code	anafi_sesso	character varying(1)	NO		Gender code.
date_of_birth	anafi_data_nascita	date	NO		Date of birth.
date_of_death	anafi_data_morte	date	NO		Date of death.
age_years	anafi_eta	numeric(4,2)	NO		Age expressed in years.
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.
validity_period	anafi_periodo	daterange	YES	GENERATED: daterange(valid_from, valid_to, '[]'::text)	Validity period as daterange generated from valid_from and valid_to.

Relationships

Outgoing foreign keys

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

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_person_children → id
• Unique: uk_person_children_child_id → person_child_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_prch_tenant	NO	btree	tenant_id
idx_prch_tenant_child_id	NO	btree	tenant_id, person_child_id) WHERE (_deleted = false
idx_prch_tenant_family_type	NO	btree	tenant_id, family_relation_type_id) WHERE (_deleted = false
idx_prch_tenant_person	NO	btree	tenant_id, person_id) WHERE (_deleted = false
idx_prch_tenant_person_validity_gist	NO	gist	tenant_id, person_id, validity_period) WHERE (_deleted = false
idx_prch_tenant_validity_gist	NO	gist	tenant_id, validity_period) WHERE (_deleted = false

Navigation

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