VREQGERAL

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLREQUISICAO DCODCOLIGADA 2 null
VREQBENEFICIO.CODCOLIGADA FKVREQBENEFICIO_VREQGERALR
VREQGERALCOMPL.CODCOLREQUISICAO FKVREQGERALCOMPL_VREQGERALR
VREQGERALPARECER.CODCOLREQUISICAO FKVREQGERALPARECER_VREQGERALR
VRSSELECOESVAGASCANDIDATOS.CODCOLREQUISICAO FKVRSSELVAGCAND_VREQGERALR
VRSSELECOESVAGASREQCANDIDATURA.CODCOLREQUISICAO FKVRSSELECOESVAGASREQC_REQGR
HATENDIMENTOBASE.CODCOLIGADA FKVREQGERAL_HATENDIMENTOEXTR
VREQTIPO.CODCOLIGADA FKVREQGERAL_VREQTIPOR
IDREQ int 4 null
VREQBENEFICIO.IDREQ FKVREQBENEFICIO_VREQGERALR
VREQGERALCOMPL.IDREQ FKVREQGERALCOMPL_VREQGERALR
VREQGERALPARECER.IDREQ FKVREQGERALPARECER_VREQGERALR
VRSSELECOESVAGASCANDIDATOS.IDREQ FKVRSSELVAGCAND_VREQGERALR
VRSSELECOESVAGASREQCANDIDATURA.IDREQ FKVRSSELECOESVAGASREQC_REQGR
JUSTIFICATIVA MEMO 2147483647 null
DATAABERTURA datetime 16,3 null
CODCOLREQUISITANTE DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKVREQGERAL_PFUNCR
CHAPAREQUISITANTE varchar 16 null
PFUNC.CHAPA FKVREQGERAL_PFUNCR
CODATENDIMENTO int 4 √ null
HATENDIMENTOBASE.CODATENDIMENTO FKVREQGERAL_HATENDIMENTOEXTR
CODLOCAL int 4 √ null
HATENDIMENTOBASE.CODLOCAL FKVREQGERAL_HATENDIMENTOEXTR
CODSTATUS int 4 √ null
VREQSTATUS.CODCLIENTE FKVREQGERAL_VREQSTATUSR
DATACANCELAMENTO datetime 16,3 √ null
DATAPREVISTA datetime 16,3 √ null
DATACONCLUSAO datetime 16,3 √ null
FINALIDADE int 4 √ null
VREQTIPO.IDTIPOREQUISICAO FKVREQGERAL_VREQTIPOR
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)
PKVREQGERAL Primary key Asc/Asc CODCOLREQUISICAO + IDREQ

Relationships

Close relationships within degrees of separation