VPPRARISCOS

15 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VASSOCPCMSOPPRA.CODCOLIGADA FKVASSOCPCMSOPPRA_VPPRARISCOSR
VEPISEGURANCA.CODCOLIGADA FKVEPISEGURANCA_VPPRARISCOSR
VHISTEPISEGURANCA.CODCOLIGADA FKVHISTEPISEGURANCA_VPPRARISCOR
VHISTMAPARISCO.CODCOLIGADA FKVHISTMAPARISCO_VPPRARISCOSR
VMAPARISCO.CODCOLIGADA FKVMAPARISCO_VPPRARISCOSR
VNIVEISMAPARISCO.CODCOLIGADA FKVNIVEISMAPARISCO_VPPRARISCR
VPERIGORISCOS.CODCOLIGADA FKVPERIGORISCOS_VPPRARISCOSR
VPPRAHISTRISCOPOSTOTRABALHO.CODCOLIGADA FKVPPRAHRPOSTOTRAB_VPPRARISCOR
VPPRAHISTRISCOSLOTACAO.CODCOLIGADA FKVPPRAHISTRISCOSLOTACAO_VPPRAR
VPPRAHISTRISCOSSECAO.CODCOLIGADA FKVPPRAHISTRISCOSSECAO_VPPRARIR
VPPRAHISTRISCOSTAREFA.CODCOLIGADA FKVPPRAHISTRISCTAR_VPPRARISCOSR
VPPRAMEDICOES.CODCOLIGADA FKVPPRAMEDICOES_VPPRARISCOSR
VPPRAMEDIDAS.CODCOLIGADA FKVPPRAMEDIDAS_VPPRARISCOSR
VPPRANIVEISRISCO.CODCOLIGADA FKVPPRANIVEISRISCO_VPPRARISCOSR
VPPRARISCODANOSAUDE.CODCOLIGADA FKVPPRARISCODANOSAUDE_VRISCOSR
VPPRARISCOFONTEGERA.CODCOLIGADA FKVPPRARISCOFONTEGERA_VRISCOSR
VPPRARISCOMEDCONTROLE.CODCOLIGADA FKVPPRARISCMEDCONT_VPPRARISCOSC
VPPRARISCOMEIOPROPAGA.CODCOLIGADA FKVPPRARISMEIOPROP_VPPRARISCOSR
VPPRARISCOPOSTOTRABALHO.CODCOLIGADA FKVPPRARISCOPOSTTRAB_VPPRARISCC
VPPRARISCOSDANOSAUDEAMB.CODCOLIGADA FKVPPRADANSAAMB_VPPRARISCOSR
VPPRARISCOSFONTEGERAAMB.CODCOLIGADA FKVPPRAFONGEAMB_VPPRARISCOSR
VPPRARISCOSLOTACAO.CODCOLIGADA FKVPPRARISCOSLOTACAO_VPPRARISOR
VPPRARISCOSMEDCONTROLEAMB.CODCOLIGADA FKFKVPPRAMEDCONTAMB_VPPRARISCOR
VPPRARISCOSMEIOPROPAGAAMB.CODCOLIGADA FKVPPRAMEIOPROPAMB_VPPRARISCOSR
VPPRARISCOSSECAO.CODCOLIGADA FKVPPRARISCOSSECAO_VPPRARISCOSR
VPPRARISCOSTAREFA.CODCOLIGADA FKVPPRARISCOSTAREFA_VPPRARISCOR
VTPMEDQUALIITEMRISCO.CODCOLIGADA FKVTPMEDQUALIITEMRISCO_VPPRARIR
CODITEMRISCO varchar 10 null
VASSOCPCMSOPPRA.CODITEMRISCO FKVASSOCPCMSOPPRA_VPPRARISCOSR
VEPISEGURANCA.CODITEMRISCO FKVEPISEGURANCA_VPPRARISCOSR
VHISTEPISEGURANCA.CODITEMRISCO FKVHISTEPISEGURANCA_VPPRARISCOR
VHISTMAPARISCO.CODITEMRISCO FKVHISTMAPARISCO_VPPRARISCOSR
VMAPARISCO.CODITEMRISCO FKVMAPARISCO_VPPRARISCOSR
VNIVEISMAPARISCO.CODITEMRISCO FKVNIVEISMAPARISCO_VPPRARISCR
VPERIGORISCOS.CODITEMRISCO FKVPERIGORISCOS_VPPRARISCOSR
VPPRAHISTRISCOPOSTOTRABALHO.CODITEMRISCO FKVPPRAHRPOSTOTRAB_VPPRARISCOR
VPPRAHISTRISCOSLOTACAO.CODITEMRISCO FKVPPRAHISTRISCOSLOTACAO_VPPRAR
VPPRAHISTRISCOSSECAO.CODITEMRISCO FKVPPRAHISTRISCOSSECAO_VPPRARIR
VPPRAHISTRISCOSTAREFA.CODITEMRISCO FKVPPRAHISTRISCTAR_VPPRARISCOSR
VPPRAMEDICOES.CODITEMRISCO FKVPPRAMEDICOES_VPPRARISCOSR
VPPRAMEDIDAS.CODITEMRISCO FKVPPRAMEDIDAS_VPPRARISCOSR
VPPRANIVEISRISCO.CODITEMRISCO FKVPPRANIVEISRISCO_VPPRARISCOSR
VPPRARISCODANOSAUDE.CODITEMRISCO FKVPPRARISCODANOSAUDE_VRISCOSR
VPPRARISCOFONTEGERA.CODITEMRISCO FKVPPRARISCOFONTEGERA_VRISCOSR
VPPRARISCOMEDCONTROLE.CODITEMRISCO FKVPPRARISCMEDCONT_VPPRARISCOSC
VPPRARISCOMEIOPROPAGA.CODITEMRISCO FKVPPRARISMEIOPROP_VPPRARISCOSR
VPPRARISCOPOSTOTRABALHO.CODITEMRISCO FKVPPRARISCOPOSTTRAB_VPPRARISCC
VPPRARISCOSDANOSAUDEAMB.CODITEMRISCO FKVPPRADANSAAMB_VPPRARISCOSR
VPPRARISCOSFONTEGERAAMB.CODITEMRISCO FKVPPRAFONGEAMB_VPPRARISCOSR
VPPRARISCOSLOTACAO.CODITEMRISCO FKVPPRARISCOSLOTACAO_VPPRARISOR
VPPRARISCOSMEDCONTROLEAMB.CODITEMRISCO FKFKVPPRAMEDCONTAMB_VPPRARISCOR
VPPRARISCOSMEIOPROPAGAAMB.CODITEMRISCO FKVPPRAMEIOPROPAMB_VPPRARISCOSR
VPPRARISCOSSECAO.CODITEMRISCO FKVPPRARISCOSSECAO_VPPRARISCOSR
VPPRARISCOSTAREFA.CODITEMRISCO FKVPPRARISCOSTAREFA_VPPRARISCOR
VTPMEDQUALIITEMRISCO.CODITEMRISCO FKVTPMEDQUALIITEMRISCO_VPPRARIR
NOMEITEMRISCO varchar 40 √ null
TIPOMEDICAO smallint 2 √ null
CODUND varchar 5 √ null
TUND.CODUND FKVPPRARISCOS_TUNDR
INATIVA DLOGICO 2 null
CODAGENTE varchar 10 null
VAGENTE.CODAGENTE FKVPPRARISCOS_VAGENTER
CODTIPOAGENTE varchar 10 √ null
VTIPOSAGENTE.CODTIPOAGENTE FKVPPRARISCOS_VTIPOSAGENTER
PARECERCIPA varchar 2000 √ null
OBSERVACAO varchar 2000 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
LEGISLACAO int 4 √ null
EPINAOAPLICAVEL smallint 2 √ null
EPCNAOAPLICAVEL smallint 2 √ null
CRITERIOSAVAL varchar 2147483647 √ null
SEVERIDADE smallint 2 ((0))
PROBABILIDADE smallint 2 ((0))

Indexes

Constraint Name Type Sort Column(s)
PKVPPRARISCOS Primary key Asc/Asc CODCOLIGADA + CODITEMRISCO
VXVPPRARISCOS Must be unique Asc/Asc/Asc/Asc CODCOLIGADA + CODITEMRISCO + CODAGENTE + CODTIPOAGENTE

Relationships

Close relationships within degrees of separation