VCANDIDATOS

102 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODPESSOA int 4 null
VCANDIDATOHISTCONSENT.CODPESSOA FKVCANDIDATOHISTCONSENT_VCANDR
PPESSOA.CODIGO FKVCANDIDATOS_PPESSOAR
FUNCIONARIO smallint 2 √ null
DATACADASTRAMENTO datetime 16,3 √ null
PRETENSAOSALARIAL RMDVALOR2 17,2 √ null
DTULTALTWEB datetime 16,3 √ null
CODAREA1 int 4 √ null
VAREACURRICULAR.CODAREA FKVCANDIDATOS_VAREACURRICULAR1R
CODAREA2 int 4 √ null
VAREACURRICULAR.CODAREA FKVCANDIDATOS_VAREACURRICULAR2R
PRETENSAOSALNEGOCIAVEL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
TEMPOEXPPROF int 4 √ null
EXPERIENCIAAREACURR1 smallint 2 √ null
EXPERIENCIAAREACURR2 smallint 2 √ null
CONTRAINDICADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
MOTIVOCONTRAINDICACAO varchar 120 √ null
DISPONIVEL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
TRABALHANDO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODPERFILCURR varchar 1 √ null
VPERFILCURRIC.CODCLIENTE FKVCANDIDATOS_VPERFILCURRICR
IDRESUMOQUALIF int 4 √ null
VMEMO.ID FKVCANDIDATOS_VMEMOR
CODNIVELHIERARQUICO int 4 √ null
VNIVELHIERARQUICO.CODNIVELHIERARQUICO FKVCANDIDATOS_VNIVELHIERARQUICR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDCONSENTIMENTO int 4 √ null
VCONSENTIMENTO.IDCONSENTIMENTO FKVCANDIDATOS_VCONSENTIMENTOR
DTCONSENTIMENTO datetime 16,3 √ null
OBSAPROVRESPLEGALCONSENT MEMO 2147483647 √ null
USUARIOAPROVRESPLEGALCONSENT varchar 80 √ null
DATAUSUAPROVRESPLEGALCONSENT datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVCANDIDATOS Primary key Asc CODPESSOA

Relationships

Close relationships within degrees of separation