Skip to main content

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 columnItalian original columnTypeNullDefault / GeneratedDescription
id``integerNOSurrogate primary key.
inclise_id``integerNOIdentifier of the related inclise record.
inclise_incli_id``integerNOIdentifier of the related inclise incli record.
inclise_codice``character varying(10)NOText value.
inclise_ragione_sociale``character varying(250)NOText value.
inclise_email``character varying(150)NOEmail address.
inclise_referente``character varying(100)NOText value.
inclise_telefono``character varying(20)NOText value.
inclise_stato``character varying(100)NOText value.
inclise_sigla_stato``character varying(2)NOText value.
inclise_comune``character varying(100)NOText value.
inclise_provincia``character varying(2)NOText value.
inclise_indirizzo``character varying(100)NOText value.
inclise_disabilitato``booleanNOBoolean flag.
inclise_cap``character varying(20)NOText value.
inclise_p1_latitudine``numeric(19,15)NOInclise p1 latitudine.
inclise_p1_longitudine``numeric(19,15)NOInclise p1 longitudine.
inclise_p2_latitudine``numeric(19,15)NOInclise p2 latitudine.
inclise_p2_longitudine``numeric(19,15)NOInclise p2 longitudine.
inclise_num_civico``character varying(20)NOText value.
inclise_lat_indirizzo``numeric(19,15)NOInclise lat indirizzo.
inclise_lon_indirizzo``numeric(19,15)NOInclise lon indirizzo.
inclise_raggio``integerNONumeric value.
inclise_responsabile_rap_id``integerNOIdentifier of the related inclise responsabile rap record.
inclise_chiuso_dal``dateNOInclise chiuso dal.
inclise_chiuso_al``dateNOInclise chiuso al.
inclise_santo_patrono_tipo``numeric(1,0)NOInclise santo patrono tipo.
inclise_santo_patrono_gg``numeric(2,0)NOInclise santo patrono gg.
inclise_santo_patrono_mese``numeric(2,0)NOInclise santo patrono mese.
inclise_dt_santo_patrono``dateNOInclise dt santo patrono.
inclise_caubol_id``character varying(4)NOIdentifier of the related inclise caubol record.
inclise_cod_giu_viaggio``character varying(4)NOText value.
inclise_v_ore_forfettizzate``integerNONumeric value.
tenant_id``integerYESTenant identifier for data isolation.
colcustom``jsonbYES'{}'::jsonbJSON payload containing additional attributes.
_deleted``booleanYESfalseFlag indicating whether the record is soft-deleted.

Relationships

Outgoing foreign keys

ConstraintLocal columnsReferencesReferenced columnsOn updateOn delete
fk_incli_idinclise_incli_id, tenant_idhr.customerscust_id, tenant_idRESTRICTRESTRICT
fk_tenant_idtenant_idcloud.tenantsten_internal_idRESTRICTCASCADE

Referenced by

From tableForeign keySource columnsTarget columns
hr.business_tripsfk_intra_inclise_idbtr_csl_id, tenant_idinclise_id, tenant_id
hr.customer_location_group_assignmentsfk_customer_location_group_assignments_locationclga_customer_location_id, tenant_idinclise_id, tenant_id

Constraints

  • Primary key: in_clienti_sedi_pkeyid
  • Unique: k_inclise_id_uniqueinclise_id, tenant_id

Indexes

NameUniqueMethodColumns / expression
idx_in_clienti_sedi_inclise_caubol_id_tenantNObtreetenant_id, inclise_caubol_id) WHERE (_deleted = false
idx_in_clienti_sedi_inclise_id_tenantNObtreetenant_id, inclise_id) WHERE (_deleted = false
idx_in_clienti_sedi_inclise_incli_id_tenantNObtreetenant_id, inclise_incli_id) WHERE (_deleted = false
idx_in_clienti_sedi_inclise_responsabile_rap_id_tenantNObtreetenant_id, inclise_responsabile_rap_id) WHERE (_deleted = false
idx_in_clienti_sedi_tenantNObtreetenant_id