VREQTRANSFLOTEPARECER

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLREQUISICAO DCODCOLIGADA 2 null
VREQTRANSFLOTEFUNC.CODCOLREQUISICAO FKVREQTRANSFLOTEPARECER_VREQTR2R
VREQTRANSFLOTE.CODCOLREQUISICAO FKVREQTRANSFLOTEPARECER_VREQTRR
PMOTMUDSECAO.CODCOLIGADA FKVREQTRANSFLOTEPARECER_PMOTMUR
IDREQ int 4 null
VREQTRANSFLOTEFUNC.IDREQ FKVREQTRANSFLOTEPARECER_VREQTR2R
VREQTRANSFLOTE.IDREQ FKVREQTRANSFLOTEPARECER_VREQTRR
IDPARECER int 4 null
VREQTRANSFLOTEFUNC.IDPARECER FKVREQTRANSFLOTEPARECER_VREQTR2R
CODCOLSOLICITANTE DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKVREQTRANSFLOTEPARECER_PFUNCR
CHAPASOLICITANTE varchar 16 null
PFUNC.CHAPA FKVREQTRANSFLOTEPARECER_PFUNCR
PARECER varchar 2147483647 √ null
DATAPARECER DDATETIME 16,3 null
DATAPREVISTA DDATETIME 16,3 √ null
CODSTATUS int 4 √ null
VREQSTATUS.CODCLIENTE FKVREQTRANSFLOTEPARECER_VREQSTR
TRANSFERIRVAGA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CRIASUBSTITUICAO DLOGICO 2 null
CODMOTMUDSECAO varchar 2 √ null
PMOTMUDSECAO.CODCLIENTE FKVREQTRANSFLOTEPARECER_PMOTMUR
SUSPENSAO DLOGICO 2 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODCOLHIERARQUIADESTINO DCODCOLIGADANULL 2 √ null
VHIERARQUIA.CODCOLIGADA FKVREQTRANSFLOTEPARECER_VHIERR
IDHIERARQUIADESTINO int 4 √ null
VHIERARQUIA.IDHIERARQUIA FKVREQTRANSFLOTEPARECER_VHIERR

Indexes

Constraint Name Type Sort Column(s)
PKVREQTRANSFLOTEPARECER Primary key Asc/Asc/Asc CODCOLREQUISICAO + IDREQ + IDPARECER

Relationships

Close relationships within degrees of separation