hr.customers

Schema: hr
English table: hr.customers
Italian original table: hr.in_clienti
Description: Registry of company customers and their master data.

Overview

• Columns: 27
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 5
• Indexes: 3

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Technical primary key (surrogate).
cust_id	incli_id	integer	NO		Functional identifier used for foreign key relationships.
cust_code	incli_codice	character varying(10)	NO		Unique alphanumeric code for the customer.
cust_business_name	incli_ragione_sociale	character varying(250)	NO		Full legal or commercial name of the customer.
cust_vat_number	incli_partita_iva	character varying(20)	NO		VAT registration number or tax ID.
cust_email	incli_email	character varying(150)	NO		Primary contact email address.
cust_contact_person	incli_referente	character varying(100)	NO		Name of the main contact person/referent.
cust_phone	incli_telefono	character varying(20)	NO		Primary contact telephone number.
cust_country	incli_stato	character varying(100)	NO		Full name of the country.
cust_city	incli_comune	character varying(100)	NO		Name of the municipality or city.
cust_province	incli_provincia	character varying(2)	NO		Province or state abbreviation.
cust_address	incli_indirizzo	character varying(100)	NO		Street name or road.
cust_house_number	incli_numero_civico	character varying(20)	NO		Building or street number.
cust_zip_code	incli_cap	character varying(20)	NO		Postal/Zip code.
cust_country_code	incli_stato_sigla	character varying(2)	NO		Two-letter ISO country code.
cust_is_enabled	incli_enabled	boolean	NO		Flag indicating if the customer is active in the system.
cust_p1_latitude	incli_p1_latitudine	numeric(19,15)	NO		Latitude for geofencing boundary point 1.
cust_p1_longitude	incli_p1_longitudine	numeric(19,15)	NO		Longitude for geofencing boundary point 1.
cust_p2_latitude	incli_p2_latitudine	numeric(19,15)	NO		Latitude for geofencing boundary point 2.
cust_p2_longitude	incli_p2_longitudine	numeric(19,15)	NO		Longitude for geofencing boundary point 2.
cust_address_latitude	incli_lat_indirizzo	numeric(19,15)	NO		Latitude coordinate of the specific address.
cust_address_longitude	incli_lon_indirizzo	numeric(19,15)	NO		Longitude coordinate of the specific address.
cust_geofence_radius	incli_raggio	integer	NO		Radius in meters for the geofencing area.
cust_account_manager_id	incli_responsabile_rap_id	integer	NO		Reference to the internal person responsible for the customer relationship.
tenant_id	tenant_id	integer	YES		Tenant identifier for data isolation.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	JSON structure for custom fields.
_deleted	_deleted	boolean	YES	false	Technical soft delete flag.

Relationships

Outgoing foreign keys

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

Referenced by

From table	Foreign key	Source columns	Target columns
hr.business_trips	fk_intra_incli_id	btr_cust_id, tenant_id	cust_id, tenant_id
hr.customer_employment_links	fk_customer_employment_links_customer	cel_customer_id, tenant_id	cust_id, tenant_id
hr.customer_group_assignments	fk_customer_group_assignments_customer	cga_customer_id, tenant_id	cust_id, tenant_id
hr.customer_profora_assignments	fk_customer_profora_assignments_customer	cha_customer_id, tenant_id	cust_id, tenant_id
hr.in_clienti_sedi	fk_incli_id	inclise_incli_id, tenant_id	cust_id, tenant_id

Constraints

• Primary key: pk_customers → id
• Unique: uk_customers_cust_id → cust_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_cust_id_tenant	NO	btree	tenant_id, cust_id) WHERE (_deleted = false
idx_cust_manager_id_tenant	NO	btree	tenant_id, cust_account_manager_id) WHERE (_deleted = false
idx_cust_tenant	NO	btree	tenant_id

Navigation

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