VPPRAHISTRISCOSTAREFA

11 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VPPRARISCOSDANOSAUDEAMB.CODCOLIGADA FKVPPRADANSAUAMB_VHISRISCOTARER
VPPRARISCOSFONTEGERAAMB.CODCOLIGADA FKVPPRAFONGEAMB_VHISRISCTAREFAR
VPPRARISCOSMEDCONTROLEAMB.CODCOLIGADA FKVPPRAMEDCONTAMB_VHISTRISTARR
VPPRARISCOSMEIOPROPAGAAMB.CODCOLIGADA FKVPPRAMEIOPROPAMB_VHISTRISTARR
VTAREFA.CODCOLIGADA FKVPPRAHISTRISCTAR_VTAREFAR
VPPRARISCOS.CODCOLIGADA FKVPPRAHISTRISCTAR_VPPRARISCOSR
CODTAREFA varchar 10 null
VPPRARISCOSDANOSAUDEAMB.CODTAREFA FKVPPRADANSAUAMB_VHISRISCOTARER
VPPRARISCOSFONTEGERAAMB.CODTAREFA FKVPPRAFONGEAMB_VHISRISCTAREFAR
VPPRARISCOSMEDCONTROLEAMB.CODTAREFA FKVPPRAMEDCONTAMB_VHISTRISTARR
VPPRARISCOSMEIOPROPAGAAMB.CODTAREFA FKVPPRAMEIOPROPAMB_VHISTRISTARR
VTAREFA.CODTAREFA FKVPPRAHISTRISCTAR_VTAREFAR
CODITEMRISCO varchar 10 null
VPPRARISCOSDANOSAUDEAMB.CODITEMRISCO FKVPPRADANSAUAMB_VHISRISCOTARER
VPPRARISCOSFONTEGERAAMB.CODITEMRISCO FKVPPRAFONGEAMB_VHISRISCTAREFAR
VPPRARISCOSMEDCONTROLEAMB.CODITEMRISCO FKVPPRAMEDCONTAMB_VHISTRISTARR
VPPRARISCOSMEIOPROPAGAAMB.CODITEMRISCO FKVPPRAMEIOPROPAMB_VHISTRISTARR
VPPRARISCOS.CODITEMRISCO FKVPPRAHISTRISCTAR_VPPRARISCOSR
CODTIPOEXPOSICAO varchar 3 √ null
VTIPOEXPOSICAO.CODTIPOEXPOSICAO FKVPPRAHISTRISCTAR_VTPEXPR
DATA datetime 16,3 null
VPPRARISCOSDANOSAUDEAMB.DATA FKVPPRADANSAUAMB_VHISRISCOTARER
VPPRARISCOSFONTEGERAAMB.DATA FKVPPRAFONGEAMB_VHISRISCTAREFAR
VPPRARISCOSMEDCONTROLEAMB.DATA FKVPPRAMEDCONTAMB_VHISTRISTARR
VPPRARISCOSMEIOPROPAGAAMB.DATA FKVPPRAMEIOPROPAMB_VHISTRISTARR
DATASAIDA datetime 16,3 √ null
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)
PKVPPRAHISTRISCOSTAREFA Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODTAREFA + CODITEMRISCO + DATA

Relationships

Close relationships within degrees of separation