`hr.customer_locations`

Schema: hr
English table: hr.customer_locations
Italian original table: hr.in_clienti_sedi
Description: Customer locations — sites and branches with operational and geographical data.

Overview

Columns: 36
Primary key: id
Outgoing foreign keys: 2
Incoming foreign keys: 2
Indexes: 5

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Surrogate primary key.
`cl_id`	`inclise_id`	`integer`	NO		Logical identifier of the customer location (unique per tenant).
`cl_customer_id`	`inclise_incli_id`	`integer`	NO		Reference to the customer.
`cl_code`	`inclise_codice`	`character varying(10)`	NO		Location code.
`cl_name`	`inclise_ragione_sociale`	`character varying(250)`	NO		Customer location name.
`cl_email`	`inclise_email`	`character varying(150)`	NO		Contact email.
`cl_contact_person`	`inclise_referente`	`character varying(100)`	NO		Contact person.
`cl_phone`	`inclise_telefono`	`character varying(20)`	NO		Contact phone number.
`cl_country`	`inclise_stato`	`character varying(100)`	NO		Country name.
`cl_country_code`	`inclise_sigla_stato`	`character varying(2)`	NO		Country ISO code.
`cl_city`	`inclise_comune`	`character varying(100)`	NO		City.
`cl_province`	`inclise_provincia`	`character varying(2)`	NO		Province.
`cl_address`	`inclise_indirizzo`	`character varying(100)`	NO		Street address.
`cl_street_number`	`inclise_num_civico`	`character varying(20)`	NO		Street number.
`cl_zip_code`	`inclise_cap`	`character varying(20)`	NO		ZIP/postal code.
`cl_disabled`	`inclise_disabilitato`	`boolean`	NO		Flag indicating whether the location is disabled.
`cl_area_p1_latitude`	`inclise_p1_latitudine`	`numeric(19,15)`	NO		Latitude of first point defining the area.
`cl_area_p1_longitude`	`inclise_p1_longitudine`	`numeric(19,15)`	NO		Longitude of first point defining the area.
`cl_area_p2_latitude`	`inclise_p2_latitudine`	`numeric(19,15)`	NO		Latitude of second point defining the area.
`cl_area_p2_longitude`	`inclise_p2_longitudine`	`numeric(19,15)`	NO		Longitude of second point defining the area.
`cl_address_latitude`	`inclise_lat_indirizzo`	`numeric(19,15)`	NO		Latitude of the address.
`cl_address_longitude`	`inclise_lon_indirizzo`	`numeric(19,15)`	NO		Longitude of the address.
`cl_radius`	`inclise_raggio`	`integer`	NO		Geofencing radius.
`cl_manager_report_id`	`inclise_responsabile_rap_id`	`integer`	NO		Reference to the responsible manager report.
`cl_closed_from`	`inclise_chiuso_dal`	`date`	NO		Closure start date.
`cl_closed_to`	`inclise_chiuso_al`	`date`	NO		Closure end date.
`cl_patron_saint_type`	`inclise_santo_patrono_tipo`	`numeric(1,0)`	NO		Type of patron saint configuration.
`cl_patron_saint_day`	`inclise_santo_patrono_gg`	`numeric(2,0)`	NO		Day of patron saint.
`cl_patron_saint_month`	`inclise_santo_patrono_mese`	`numeric(2,0)`	NO		Month of patron saint.
`cl_patron_saint_date`	`inclise_dt_santo_patrono`	`date`	NO		Exact date of patron saint.
`cl_causal_id`	`inclise_caubol_id`	`character varying(4)`	NO		Reference to causal.
`cl_travel_justification_code`	`inclise_cod_giu_viaggio`	`character varying(4)`	NO		Travel justification code.
`cl_flat_travel_hours`	`inclise_v_ore_forfettizzate`	`integer`	NO		Flat-rate travel hours.
`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.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
`fk_cl_customer`	`cl_customer_id, tenant_id`	`hr.customers`	`cust_id, tenant_id`	RESTRICT	RESTRICT
`fk_tenant_id`	`tenant_id`	`cloud.tenants`	`ten_internal_id`	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
`hr.business_trips`	`fk_intra_inclise_id`	`btr_csl_id, tenant_id`	`cl_id, tenant_id`
`hr.customer_location_group_assignments`	`fk_customer_location_group_assignments_location`	`clga_customer_location_id, tenant_id`	`cl_id, tenant_id`

Constraints

Primary key: customer_locations_pkey → id
Unique: uk_cl_id_tenant → cl_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
`idx_customer_locations_cl_causal_id_tenant`	NO	`btree`	`tenant_id, cl_causal_id) WHERE (_deleted = false`
`idx_customer_locations_cl_id_tenant`	NO	`btree`	`tenant_id, cl_id) WHERE (_deleted = false`
`idx_customer_locations_cl_customer_id_tenant`	NO	`btree`	`tenant_id, cl_customer_id) WHERE (_deleted = false`
`idx_customer_locations_cl_manager_report_id_tenant`	NO	`btree`	`tenant_id, cl_manager_report_id) WHERE (_deleted = false`
`idx_customer_locations_tenant`	NO	`btree`	`tenant_id`

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

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​