VREQTIPO

38 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VCAMPOSREQGERAL.CODCOLIGADA FKVCAMPOSREQGERAL_VREQTIPOR
VREQFLUXOREPASSEHIERARQUIA.CODCOLIGADA FKVREQFLUXREPHIER_TIPOR
VREQGERAL.CODCOLREQUISICAO FKVREQGERAL_VREQTIPOR
VREQMAPEAMENTOFLUXO.CODCOLIGADA FKVREQMAPEAMENTOFLUXO_VREQTIPOR
VREQTIPOACOESNIVELHIERARQUIA.CODCOLIGADA FKVREQTPACOESNVLHIER_VREQTIPOR
VREQTIPOALERTA.CODCOLIGADA FKVREQTIPOALERTA_VREQTIPOR
VREQTIPOPARAMS.CODCOLIGADA FKVREQTIPOPARAMS_VREQTIPOR
RRPTREPORT.CODCOLIGADA FKVREQTIPO_RRPTREPORTR
VEMAIL.CODCOLIGADA FKVREQTIPO_VEMAIL4R
IDTIPOREQUISICAO int 4 null
VCAMPOSREQGERAL.IDTIPOREQ FKVCAMPOSREQGERAL_VREQTIPOR
VREQFLUXOREPASSEHIERARQUIA.TIPOREQ FKVREQFLUXREPHIER_TIPOR
VREQGERAL.FINALIDADE FKVREQGERAL_VREQTIPOR
VREQMAPEAMENTOFLUXO.IDTIPOREQUISICAO FKVREQMAPEAMENTOFLUXO_VREQTIPOR
VREQTIPOACOESNIVELHIERARQUIA.IDTIPOREQUISICAO FKVREQTPACOESNVLHIER_VREQTIPOR
VREQTIPOALERTA.IDTIPOREQUISICAO FKVREQTIPOALERTA_VREQTIPOR
VREQTIPOPARAMS.IDTIPOREQUISICAO FKVREQTIPOPARAMS_VREQTIPOR
TIPOREQUISICAO varchar 50 null
ATIVO DLOGICO 2 null
CODGRUPOATENDIMENTO int 4 √ null
CODTIPOATENDIMENTO int 4 √ null
PERCENTUALAUMENTO DVALOR2 17,2 √ null
IDRELGERENCIAL varchar 30 √ null
RRELAT.CODRELATORIO FKVREQTIPO_RRELATR
FINALIDADE int 4 null
CODCOLIGADAREL DCODCOLIGADANULL 2 √ null
RRELAT.CODCOLIGADA FKVREQTIPO_RRELATR
CODAPLIC varchar 1 √ null
RRELAT.CODAPLIC FKVREQTIPO_RRELATR
INSTRUCAO varchar 2000 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODEMAILREQAPROVADA varchar 10 √ null
VEMAIL.CODEMAIL FKVREQTIPO_VEMAILR
CODEMAILREQREPROVADA varchar 10 √ null
VEMAIL.CODEMAIL FKVREQTIPO_VEMAIL2R
CODEMAILREQCANCELADA varchar 10 √ null
VEMAIL.CODEMAIL FKVREQTIPO_VEMAIL3R
CODEMAILREQEFETIVADA varchar 10 √ null
VEMAIL.CODEMAIL FKVREQTIPO_VEMAIL4R
CODEMAILREQENCAMINHADA varchar 10 √ null
VEMAIL.CODEMAIL FKVREQTIPO_VEMAIL6R
IDRELATORIO int 4 √ null
RRPTREPORT.ID FKVREQTIPO_RRPTREPORTR

Indexes

Constraint Name Type Sort Column(s)
PKVREQTIPO Primary key Asc/Asc CODCOLIGADA + IDTIPOREQUISICAO

Relationships

Close relationships within degrees of separation