VRSSELECOESVAGASETAPAS

37 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VRSSELECOESPESSOASETAPAS.CODCOLIGADA FKVRSSELPESSETP_VRSSELVGETPSR
VRSSELECOESVAGASETAPASDESPESAS.CODCOLIGADA FKVRSSELVGETPDESP_VRSSELVGETPR
VRSSELECOESVAGASETAPASHABIL.CODCOLIGADA FKVRSSELVAGETAPHAB_VRSSELVGETAR
VRSSELECOESVAGASETAPASPRED.CODCOLIGADA FKVRSSELECVASETPRED_VRSSELECOER
VRSSELECOESVAGASETAPASREQUISIT.CODCOLIGADA FKVRSSELVGETPREQ_VRSSELVGSETAPR
GFILTROS.CODCOLIGADA FKVRSSELVAGETAP_GFILTROSR
VRSSELECOESVAGAS.CODCOLIGADA FKVRSSELVAGETAP_VRSSELECOESVAGR
GFORMULA.CODCOLIGADA FKVRSSELVAGETAP_GFORMULAR
VRSETAPAS.CODCOLIGADA FKVRSSELVAGETAP_VRSETAPASR
CODSELECAO varchar 10 null
VRSSELECOESPESSOASETAPAS.CODSELECAO FKVRSSELPESSETP_VRSSELVGETPSR
VRSSELECOESVAGASETAPASDESPESAS.CODSELECAO FKVRSSELVGETPDESP_VRSSELVGETPR
VRSSELECOESVAGASETAPASHABIL.CODSELECAO FKVRSSELVAGETAPHAB_VRSSELVGETAR
VRSSELECOESVAGASETAPASPRED.CODSELECAO FKVRSSELECVASETPRED_VRSSELECOER
VRSSELECOESVAGASETAPASREQUISIT.CODSELECAO FKVRSSELVGETPREQ_VRSSELVGSETAPR
VRSSELECOESVAGAS.CODSELECAO FKVRSSELVAGETAP_VRSSELECOESVAGR
CODVAGA varchar 10 null
VRSSELECOESPESSOASETAPAS.CODVAGA FKVRSSELPESSETP_VRSSELVGETPSR
VRSSELECOESVAGASETAPASDESPESAS.CODVAGA FKVRSSELVGETPDESP_VRSSELVGETPR
VRSSELECOESVAGASETAPASHABIL.CODVAGA FKVRSSELVAGETAPHAB_VRSSELVGETAR
VRSSELECOESVAGASETAPASPRED.CODVAGA FKVRSSELECVASETPRED_VRSSELECOER
VRSSELECOESVAGASETAPASREQUISIT.CODVAGA FKVRSSELVGETPREQ_VRSSELVGSETAPR
VRSSELECOESVAGAS.CODVAGA FKVRSSELVAGETAP_VRSSELECOESVAGR
CODETAPA varchar 10 null
VRSSELECOESPESSOASETAPAS.CODETAPA FKVRSSELPESSETP_VRSSELVGETPSR
VRSSELECOESVAGASETAPASDESPESAS.CODETAPA FKVRSSELVGETPDESP_VRSSELVGETPR
VRSSELECOESVAGASETAPASHABIL.CODETAPA FKVRSSELVAGETAPHAB_VRSSELVGETAR
VRSSELECOESVAGASETAPASPRED.CODETAPA FKVRSSELECVASETPRED_VRSSELECOER
VRSSELECOESVAGASETAPASREQUISIT.CODETAPA FKVRSSELVGETPREQ_VRSSELVGSETAPR
VRSETAPAS.CODETAPA FKVRSSELVAGETAP_VRSETAPASR
DATAABERTURA DDATETIME 16,3 null
DATAFECHAMENTO DDATETIME 16,3 √ null
PONTUACAO_ATUAL int 4 √ null
PONTUACAO_MINIMA int 4 √ null
PONTUACAO_MAXIMA int 4 √ null
ADEQUACAO_MINIMA int 4 √ null
OBSERVACAO varchar 4000 √ null
CODSTATUS varchar 2 null
VRSTIPOSETAPA.CODCLIENTE FKVRSSELVAGETAP_VRSTIPOSETAPAR
EXECUTADO int 4 √ null
ORDENARPOR smallint 2 √ null
CODAPLICACAO varchar 1 √ null
GFORMULA.APLICACAO FKVRSSELVAGETAP_GFORMULAR
CODFORMULA varchar 8 √ null
GFORMULA.CODIGO FKVRSSELVAGETAP_GFORMULAR
CODFILTRO int 4 √ null
GFILTROS.ID FKVRSSELVAGETAP_GFILTROSR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
OBRIGATORIA smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVRSSELECOESVAGASETAPAS Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODSELECAO + CODVAGA + CODETAPA

Relationships

Close relationships within degrees of separation