VCANDIDATOSCIPA

35 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKVCANDIDATOSCIPA_PFUNCR
VELEICAO.CODCOLIGADA FKVCANDIDATOSCIPA_VELEICAOR
CODCOMISSAO varchar 10 null
VELEICAO.CODCOMISSAO FKVCANDIDATOSCIPA_VELEICAOR
CODELEICAO varchar 10 null
VELEICAO.CODELEICAO FKVCANDIDATOSCIPA_VELEICAOR
CODPESSOA int 4 null
PPESSOA.CODIGO FKVCANDIDATOSCIPA_PPESSOAR
NUMVOTOS int 4 √ null
DTCANDIDATURA datetime 16,3 null
ORIGEMPORTAL DLOGICO 2 √ (0)
IDINSCRICAO int 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DTCANCELAMENTO DDATETIME 16,3 √ null
CODESTABILIDADE int 4 √ null
PESTABILIDADE.CODIGO FKVCANDIDATOSCIPA_PESTABILIDR
CHAPA DCHAPANULL 16 √ null
PFUNC.CHAPA FKVCANDIDATOSCIPA_PFUNCR

Indexes

Constraint Name Type Sort Column(s)
PKVCANDIDATOSCIPA Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODCOMISSAO + CODELEICAO + CODPESSOA

Relationships

Close relationships within degrees of separation