VPPRARISCOSDANOSAUDEAMB

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VPPRARISCODANOSAUDE.CODCOLIGADA FKVPPRADANSAAMB_VRISCDANOSAUDER
VHISTMAPARISCO.CODCOLIGADA FKVPPRADANOSAUDEAMB_VHISTMPRISR
VPPRAHISTRISCOSSECAO.CODCOLIGADA FKVPPRADANSAUAMB_VHISTRISCOSECR
VPPRAHISTRISCOSTAREFA.CODCOLIGADA FKVPPRADANSAUAMB_VHISRISCOTARER
VPPRAHISTRISCOPOSTOTRABALHO.CODCOLIGADA FKVPPRADASAAMB_VHISTRIPOSTOTRAR
VPPRAHISTRISCOSLOTACAO.CODCOLIGADA FKVPPRADANSAUAMB_VHISTRISCLOTAR
VPPRARISCOS.CODCOLIGADA FKVPPRADANSAAMB_VPPRARISCOSR
CODITEMRISCO varchar 10 null
VPPRAHISTRISCOSTAREFA.CODITEMRISCO FKVPPRADANSAUAMB_VHISRISCOTARER
VPPRAHISTRISCOSLOTACAO.CODITEMRISCO FKVPPRADANSAUAMB_VHISTRISCLOTAR
VPPRAHISTRISCOPOSTOTRABALHO.CODITEMRISCO FKVPPRADASAAMB_VHISTRIPOSTOTRAR
VPPRARISCODANOSAUDE.CODITEMRISCO FKVPPRADANSAAMB_VRISCDANOSAUDER
VPPRARISCOS.CODITEMRISCO FKVPPRADANSAAMB_VPPRARISCOSR
VHISTMAPARISCO.CODITEMRISCO FKVPPRADANOSAUDEAMB_VHISTMPRISR
VPPRAHISTRISCOSSECAO.CODITEMRISCO FKVPPRADANSAUAMB_VHISTRISCOSECR
CODDANOSAUDE varchar 10 null
VPPRARISCODANOSAUDE.CODDANOSAUDE FKVPPRADANSAAMB_VRISCDANOSAUDER
CODPOSTOTRABALHO varchar 25 √ null
VPPRAHISTRISCOPOSTOTRABALHO.CODPOSTOTRABALHO FKVPPRADASAAMB_VHISTRIPOSTOTRAR
CODSECAOLOT varchar 35 √ null
VPPRAHISTRISCOSLOTACAO.CODSECAO FKVPPRADANSAUAMB_VHISTRISCLOTAR
CODFUNCAOLOT varchar 10 √ null
VPPRAHISTRISCOSLOTACAO.CODFUNCAO FKVPPRADANSAUAMB_VHISTRISCLOTAR
CODSECAO varchar 35 √ null
VPPRAHISTRISCOSSECAO.CODSECAO FKVPPRADANSAUAMB_VHISTRISCOSECR
CODTAREFA varchar 10 √ null
VPPRAHISTRISCOSTAREFA.CODTAREFA FKVPPRADANSAUAMB_VHISRISCOTARER
CODLOCALTRABALHO varchar 10 √ null
VHISTMAPARISCO.CODLOCALTRABALHO FKVPPRADANOSAUDEAMB_VHISTMPRISR
DATA datetime 16,3 null
VPPRAHISTRISCOSSECAO.DATA FKVPPRADANSAUAMB_VHISTRISCOSECR
VPPRAHISTRISCOPOSTOTRABALHO.DATA FKVPPRADASAAMB_VHISTRIPOSTOTRAR
VPPRAHISTRISCOSTAREFA.DATA FKVPPRADANSAUAMB_VHISRISCOTARER
VHISTMAPARISCO.DATA FKVPPRADANOSAUDEAMB_VHISTMPRISR
VPPRAHISTRISCOSLOTACAO.DATA FKVPPRADANSAUAMB_VHISTRISCLOTAR
INDDANOSAUDE int 4 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)
PKVPPRARISCOSDANOSAUDEAMB Primary key Asc/Asc CODCOLIGADA + INDDANOSAUDE
VXDANOSAUDECODFUNCAOLOT Performance Asc/Asc CODFUNCAOLOT + CODCOLIGADA
VXDANOSAUDECODLOCALTRABALHO Performance Asc/Asc CODLOCALTRABALHO + CODCOLIGADA
VXDANOSAUDECODPOSTOTRABALHO Performance Asc/Asc CODPOSTOTRABALHO + CODCOLIGADA
VXDANOSAUDECODSECAO Performance Asc/Asc CODSECAO + CODCOLIGADA
VXDANOSAUDECODSECAOLOT Performance Asc/Asc CODSECAOLOT + CODCOLIGADA
VXDANOSAUDECODTAREFA Performance Asc/Asc CODTAREFA + CODCOLIGADA

Relationships

Close relationships within degrees of separation