VREQTRANSFLOTEFUNC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLREQUISICAO DCODCOLIGADA 2 null
VREQTRANSFLOTE.CODCOLREQUISICAO FKVREQTRANSFLOTEFUNC_VREQTRANSR
VREQTRANSFLOTEPARECER.CODCOLREQUISICAO FKVREQTRANSFLOTEPARECER_VREQTR2R
IDREQ int 4 null
VREQTRANSFLOTE.IDREQ FKVREQTRANSFLOTEFUNC_VREQTRANSR
VREQTRANSFLOTEPARECER.IDREQ FKVREQTRANSFLOTEPARECER_VREQTR2R
CODCOLORIGEM DCODCOLIGADA 2 null
VPOSICAO.CODCOLIGADA FKVREQTRANSFLOTEFUNC_VPOSICAOR
PFUNC.CODCOLIGADA FKVREQTRANSFLOTEFUNC_PFUNCR
PSECAO.CODCOLIGADA FKVREQTRANSFLOTEFUNC_PSECAOR
GFILIAL.CODCOLIGADA FKVREQTRANSFLOTEFUNC_GFILIALR
VHIERARQUIA.CODCOLIGADA FKVREQTRANSFLOTEFUNC_VHIERARQR
CHAPATRANSF varchar 16 null
PFUNC.CHAPA FKVREQTRANSFLOTEFUNC_PFUNCR
CODFILIALORIGEM smallint 2 null
GFILIAL.CODFILIAL FKVREQTRANSFLOTEFUNC_GFILIALR
CODSECAOORIGEM varchar 35 null
PSECAO.CODIGO FKVREQTRANSFLOTEFUNC_PSECAOR
CODCOLREQSUBSTITUICAO DCODCOLIGADANULL 2 √ null
VREQSUBSTITUICAO.CODCOLREQUISICAO FKVREQTRANSFLOTEFUNC_VREQSUBSTR
IDREQSUBSTITUICAO int 4 √ null
VREQSUBSTITUICAO.IDREQ FKVREQTRANSFLOTEFUNC_VREQSUBSTR
IDPARECER int 4 √ null
VREQTRANSFLOTEPARECER.IDPARECER FKVREQTRANSFLOTEPARECER_VREQTR2R
DATACONCLUSAO DDATETIME 16,3 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
REMOVIDO DLOGICO 2 ((0))
IDHIERARQUIAORIGEM int 4 √ null
VHIERARQUIA.IDHIERARQUIA FKVREQTRANSFLOTEFUNC_VHIERARQR
IDPOSICAOORIGEM int 4 √ null
VPOSICAO.IDPOSICAO FKVREQTRANSFLOTEFUNC_VPOSICAOR

Indexes

Constraint Name Type Sort Column(s)
PKVREQTRANSFLOTEFUNC Primary key Asc/Asc/Asc/Asc CODCOLREQUISICAO + IDREQ + CODCOLORIGEM + CHAPATRANSF

Relationships

Close relationships within degrees of separation