VMEMBROSGRUPOAVALIACAO

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VGRUPOAVALIACAO.CODCOLIGADA FKVMEMBGRPAVALIACAO_VGRPAVALR
PFUNC.CODCOLIGADA FKVMEMBGRPAVALIACAO_PFUNCR
GCOLIGADA.CODCOLIGADA FKVMEMBGRPAVALIACAO_GCOLIGADAR
VCONTROLEMETA.CODCOLIGADA FKVMEMBGRPAVAL_VCONTROLEMETAR
PEXTERNO.CODCOLIGADA FKVMEMBGRPAVALIACAO_PEXTERNOR
CODCONTROLEMETA int 4 null
VGRUPOAVALIACAO.CODCONTROLEMETA FKVMEMBGRPAVALIACAO_VGRPAVALR
VCONTROLEMETA.CODCONTROLEMETA FKVMEMBGRPAVAL_VCONTROLEMETAR
ID int 4 null
CODPESSOA int 4 null
PPESSOA.CODIGO FKVMEMBGRPAVALIACAO_PPESSOAR
CHAPA DCHAPANULL 16 √ null
PFUNC.CHAPA FKVMEMBGRPAVALIACAO_PFUNCR
CODEXTERNORESP DCHAPANULL 16 √ null
PEXTERNO.CODEXTERNO FKVMEMBGRPAVALIACAO_PEXTERNOR
CODGRUPOAVALIACAO int 4 null
VGRUPOAVALIACAO.ID FKVMEMBGRPAVALIACAO_VGRPAVALR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVMEMBROSGRUPOAVALIACAO Primary key Asc/Asc/Asc CODCOLIGADA + CODCONTROLEMETA + ID

Relationships

Close relationships within degrees of separation