VLNT

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VLNTCOMPCALC.CODCOLIGADA FKVLNTCOMPCALC_VLNTR
VLNTPESSOAS.CODCOLIGADA FKVLNTPESSOAS_VLNTR
VLNTPESSOASCOMP.CODCOLIGADA FKVLNTPESSOASCOMP_VLNTR
VLNTPESSOASREQACESSO.CODCOLIGADA FKVLNTPESSOASREQACESSO_VLNTR
VLNTTPDEMANDASCALC.CODCOLIGADA FKVLNTTPDEMCALC_VLNTR
VPDI.CODCOLIGADA FKVPDI_VLNTR
VPDISUGESTAO.CODCOLIGADALNT FKVPDISUGESTAO_VLNTR
VTURMALNT.CODCOLIGADA FKVTURMALNT_VLNTR
GFORMULA.CODCOLIGADA FKVLNT_GFORMULAR
CODLNT varchar 16 null
VLNTCOMPCALC.CODLNT FKVLNTCOMPCALC_VLNTR
VLNTPESSOAS.CODLNT FKVLNTPESSOAS_VLNTR
VLNTPESSOASCOMP.CODLNT FKVLNTPESSOASCOMP_VLNTR
VLNTPESSOASREQACESSO.CODLNT FKVLNTPESSOASREQACESSO_VLNTR
VLNTTPDEMANDASCALC.CODLNT FKVLNTTPDEMCALC_VLNTR
VPDI.CODLNT FKVPDI_VLNTR
VPDISUGESTAO.CODLNT FKVPDISUGESTAO_VLNTR
VTURMALNT.CODLNT FKVTURMALNT_VLNTR
DESCLNT varchar 50 null
DTINICIO datetime 16,3 null
DTTERMINO datetime 16,3 null
DTFECHAMENTO datetime 16,3 √ null
TPDISTRPESSOA smallint 2 (0)
CODAPLICACAO varchar 1 null
GFORMULA.APLICACAO FKVLNT_GFORMULAR
CODFORMPESSOA varchar 8 √ null
GFORMULA.CODIGO FKVLNT_GFORMULAR
CODFILTROPESSOA int 4 √ null
IDOBS int 4 √ null
VMEMO.ID FKVLNT_VMEMOR
TPDEMANDA smallint 2 (0)
TPCOMPETENCIA smallint 2 (0)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
FORMATOSUGESTOESCURSO smallint 2 √ null
OPCAOPESQUISA smallint 2 √ null
EXIGIDO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DESEJADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
FUNCAO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
SECAO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
LOTACAO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
POSTOTRABALHO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
TAREFA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
EXPIRADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ALERTA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
FUNCIONARIO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
NIVELCARREIRA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0

Indexes

Constraint Name Type Sort Column(s)
PKVLNT Primary key Asc/Asc CODCOLIGADA + CODLNT

Relationships

Close relationships within degrees of separation