hr.addresses

Schema: hr
English table: hr.addresses
Italian original table: hr.recapiti
Description: Polymorphic table storing physical addresses for various entities (employees, companies, etc.) with temporal validity.

Overview

• Columns: 20
• 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.
addr_id	recp_id	integer	NO		Identifier of the related addr record.
addr_source_table	recp_tabella	character varying(10)	NO		Name of the source table the address refers to (polymorphic reference).
addr_source_id	recp_tabella_id	integer	NO		ID of the record in the source table.
addr_type	recp_tipo	character varying(10)	NO		Type of address, e.g., legal, residential, mailing.
addr_street	recp_indirizzo	character varying(60)	NO		Text value.
addr_postal_code	recp_cap	character varying(5)	NO		Postal or ZIP code.
addr_city	recp_comune	character varying(40)	NO		Text value.
addr_province_code	recp_provincia	character varying(2)	NO		Code for addr province.
addr_country	recp_stato	character varying(30)	NO		Text value.
addr_valid_from	recp_dal	date	NO		Boundary value used for range filtering (start/end).
addr_notes	recp_note	character varying(100)	NO		Free-form notes.
addr_house_number	recp_num_civico	character varying(10)	NO		Text value.
addr_latitude	recp_latitudine	numeric(19,15)	NO		Addr latitude.
addr_longitude	recp_longitudine	numeric(19,15)	NO		Addr longitude.
tenant_id	tenant_id	integer	YES		Tenant identifier for data isolation.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	JSON payload containing additional attributes.
_deleted	_deleted	boolean	YES	false	Flag indicating whether the record is soft-deleted.
addr_valid_to	recp_al	date	YES		Boundary value used for range filtering (start/end).
addr_period	recp_periodo	daterange	YES	GENERATED: daterange(addr_valid_from, addr_valid_to, '[]'::text)	Temporal range of validity (daterange) for the address.

Relationships

Outgoing foreign keys

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

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_addr → id
• Unique: uk_addr_id_tenant → addr_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_addr_id_tenant	NO	btree	tenant_id, addr_id) WHERE (_deleted = false
idx_addr_period_gist	NO	gist	tenant_id, addr_period) WHERE (_deleted = false
idx_addr_polymorphic_tenant	NO	btree	tenant_id, addr_source_table, addr_source_id) WHERE (_deleted = false
idx_addr_source_id_tenant	NO	btree	tenant_id, addr_source_id) WHERE (_deleted = false
idx_addr_source_period_gist	NO	gist	tenant_id, addr_source_table, addr_source_id, addr_period) WHERE (_deleted = false
idx_addr_tenant	NO	btree	tenant_id

Navigation

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