VMETASDOCONTROLE

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VATRIBUICOESMETAS.CODCOLIGADA FKVATRIBMETAS_VMETASDOCONTRLR
VLANCAMENTOSACOESMETAS.CODCOLIGADA FKVLANCACOMETAS_VMETASDOCONTRLR
VLANCAMENTOSMETAS.CODCOLIGADA FKVLANCAMMETAS_VMETASDOCONTRLR
GCOLIGADA.CODCOLIGADA FKVMETASDOCONTROLE_GCOLIGADAR
VCONTROLEMETA.CODCOLIGADA FKVMETASDOCONTRL_VCONTROLEMETAR
CODCONTROLEMETA int 4 null
VATRIBUICOESMETAS.CODCONTROLEMETA FKVATRIBMETAS_VMETASDOCONTRLR
VLANCAMENTOSACOESMETAS.CODCONTROLEMETA FKVLANCACOMETAS_VMETASDOCONTRLR
VLANCAMENTOSMETAS.CODCONTROLEMETA FKVLANCAMMETAS_VMETASDOCONTRLR
VCONTROLEMETA.CODCONTROLEMETA FKVMETASDOCONTRL_VCONTROLEMETAR
CODMETA int 4 null
VATRIBUICOESMETAS.CODMETA FKVATRIBMETAS_VMETASDOCONTRLR
VLANCAMENTOSACOESMETAS.CODMETA FKVLANCACOMETAS_VMETASDOCONTRLR
VLANCAMENTOSMETAS.CODMETA FKVLANCAMMETAS_VMETASDOCONTRLR
NOME varchar 100 null
EPLANILHASEXP.NOME Implied ConstraintR
DESCRICAO MEMO 2147483647 √ null
ATIVO smallint 2 √ null
VALORREFERENCIA DFLOAT 8 √ null
CODGRUPOMETA varchar 10 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
VARIACAOCONSIDERADA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PESO int 4 √ null
FORMAAVALIACAO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ACEITEPARTICIPANTES DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
AVALIADOVISUALIZA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
AVALIADOLANCARESULTADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
APROVACAORESPONSAVEL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
STATUS smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVMETASDOCONTROLE Primary key Asc/Asc/Asc CODCOLIGADA + CODCONTROLEMETA + CODMETA

Relationships

Close relationships within degrees of separation