VCOMISSAO

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VCOMISSAOEVIDENCIAS.CODCOLIGADA FKVCOMISSAOEVIDENCIAS_VCOMISSAR
VCOMISSAOSECAO.CODCOLIGADA FKVCOMISSAOSECAO_VCOMISSAOR
VCOMISSAOTPFUNC.CODCOLIGADA FKVCOMISSAOTPFUNC_VCOMISSAOR
VELEICAO.CODCOLIGADA FKVELEICAO_VCOMISSAOR
VMETAS.CODCOLIGADA FKVMETAS_VCOMISSAOR
VREPRESENTANTE.CODCOLIGADA FKVREPRESENTANTE_VCOMISSAOR
VREUNIAO.CODCOLIGADA FKVREUNIAO_VCOMISSAOR
VSPAT.CODCOLIGADA FKVSPAT_VCOMISSAOR
CODCOMISSAO varchar 10 null
VCOMISSAOEVIDENCIAS.CODCOMISSAO FKVCOMISSAOEVIDENCIAS_VCOMISSAR
VCOMISSAOSECAO.CODCOMISSAO FKVCOMISSAOSECAO_VCOMISSAOR
VCOMISSAOTPFUNC.CODCOMISSAO FKVCOMISSAOTPFUNC_VCOMISSAOR
VELEICAO.CODCOMISSAO FKVELEICAO_VCOMISSAOR
VMETAS.CODCOMISSAO FKVMETAS_VCOMISSAOR
VREPRESENTANTE.CODCOMISSAO FKVREPRESENTANTE_VCOMISSAOR
VREUNIAO.CODCOMISSAO FKVREUNIAO_VCOMISSAOR
VSPAT.CODCOMISSAO FKVSPAT_VCOMISSAOR
NOME varchar 40 √ null
DATACRIACAO datetime 16,3 null
DTINICIOVIGENCIA datetime 16,3 null
DTTERMINOVIGENCIA datetime 16,3 null
CODFILIAL int 4 √ null
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)
PKVCOMISSAO Primary key Asc/Asc CODCOLIGADA + CODCOMISSAO

Relationships

Close relationships within degrees of separation