hr.in_clienti_sedi

Schema: hr
English table: hr.in_clienti_sedi
Italian original table:
Description: Records for in clienti sedi.

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	``	integer	NO		Surrogate primary key.
inclise_id	``	integer	NO		Identifier of the related inclise record.
inclise_incli_id	``	integer	NO		Identifier of the related inclise incli record.
inclise_codice	``	character varying(10)	NO		Text value.
inclise_ragione_sociale	``	character varying(250)	NO		Text value.
inclise_email	``	character varying(150)	NO		Email address.
inclise_referente	``	character varying(100)	NO		Text value.
inclise_telefono	``	character varying(20)	NO		Text value.
inclise_stato	``	character varying(100)	NO		Text value.
inclise_sigla_stato	``	character varying(2)	NO		Text value.
inclise_comune	``	character varying(100)	NO		Text value.
inclise_provincia	``	character varying(2)	NO		Text value.
inclise_indirizzo	``	character varying(100)	NO		Text value.
inclise_disabilitato	``	boolean	NO		Boolean flag.
inclise_cap	``	character varying(20)	NO		Text value.
inclise_p1_latitudine	``	numeric(19,15)	NO		Inclise p1 latitudine.
inclise_p1_longitudine	``	numeric(19,15)	NO		Inclise p1 longitudine.
inclise_p2_latitudine	``	numeric(19,15)	NO		Inclise p2 latitudine.
inclise_p2_longitudine	``	numeric(19,15)	NO		Inclise p2 longitudine.
inclise_num_civico	``	character varying(20)	NO		Text value.
inclise_lat_indirizzo	``	numeric(19,15)	NO		Inclise lat indirizzo.
inclise_lon_indirizzo	``	numeric(19,15)	NO		Inclise lon indirizzo.
inclise_raggio	``	integer	NO		Numeric value.
inclise_responsabile_rap_id	``	integer	NO		Identifier of the related inclise responsabile rap record.
inclise_chiuso_dal	``	date	NO		Inclise chiuso dal.
inclise_chiuso_al	``	date	NO		Inclise chiuso al.
inclise_santo_patrono_tipo	``	numeric(1,0)	NO		Inclise santo patrono tipo.
inclise_santo_patrono_gg	``	numeric(2,0)	NO		Inclise santo patrono gg.
inclise_santo_patrono_mese	``	numeric(2,0)	NO		Inclise santo patrono mese.
inclise_dt_santo_patrono	``	date	NO		Inclise dt santo patrono.
inclise_caubol_id	``	character varying(4)	NO		Identifier of the related inclise caubol record.
inclise_cod_giu_viaggio	``	character varying(4)	NO		Text value.
inclise_v_ore_forfettizzate	``	integer	NO		Numeric value.
tenant_id	``	integer	YES		Tenant identifier for data isolation.
colcustom	``	jsonb	YES	'{}'::jsonb	JSON payload containing additional attributes.
_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_incli_id	inclise_incli_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	inclise_id, tenant_id
hr.customer_location_group_assignments	fk_customer_location_group_assignments_location	clga_customer_location_id, tenant_id	inclise_id, tenant_id

Constraints

• Primary key: in_clienti_sedi_pkey → id
• Unique: k_inclise_id_unique → inclise_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_in_clienti_sedi_inclise_caubol_id_tenant	NO	btree	tenant_id, inclise_caubol_id) WHERE (_deleted = false
idx_in_clienti_sedi_inclise_id_tenant	NO	btree	tenant_id, inclise_id) WHERE (_deleted = false
idx_in_clienti_sedi_inclise_incli_id_tenant	NO	btree	tenant_id, inclise_incli_id) WHERE (_deleted = false
idx_in_clienti_sedi_inclise_responsabile_rap_id_tenant	NO	btree	tenant_id, inclise_responsabile_rap_id) WHERE (_deleted = false
idx_in_clienti_sedi_tenant	NO	btree	tenant_id

Navigation

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