cte_destinatario

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cte_destinatario_id numeric 10 null
cte_destinatario_uu varchar 36 √ NULL::character varying
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 null
cte_dest_cnpj varchar 14 √ null
cte_dest_cpf varchar 11 √ null
cte_dest_ie varchar 14 √ NULL::character varying
cte_dest_xnome varchar 60 √ NULL::character varying
cte_dest_fone varchar 14 √ null
cte_dest_isuf varchar 9 √ null
cte_enderdest_xlgr varchar 255 √ NULL::character varying
cte_enderdest_nro varchar 60 √ NULL::character varying
cte_enderdest_xcpl varchar 60 √ NULL::character varying
cte_enderdest_xbairro varchar 60 √ NULL::character varying
cte_enderdest_cmun varchar 7 √ null
cte_enderdest_xmun varchar 60 √ NULL::character varying
cte_enderdest_cep varchar 8 √ null
cte_enderdest_uf varchar 2 √ NULL::character varying
cte_enderdest_cpais varchar 4 √ null
cte_enderdest_xpais varchar 60 √ NULL::character varying
cte_dest_email varchar 60 √ NULL::character varying
cte_info_id numeric 10 √ null
cte_info.cte_info_id cteinfo_ctedestinatarios R
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_ctedestinatarios R
c_bpartner_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_ctedestinata R

Indexes

Constraint Name Type Sort Column(s)
cte_destinatario_key Primary key Asc cte_destinatario_id
cte_destinatario_uu_idx Must be unique Asc cte_destinatario_uu

Check Constraints

Constraint Name Constraint
cte_destinatario_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation