VPPRAHISTRISCOSSECAO

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VPPRARISCOSDANOSAUDEAMB.CODCOLIGADA FKVPPRADANSAUAMB_VHISTRISCOSECR
VPPRARISCOSFONTEGERAAMB.CODCOLIGADA FKVPPRAFONGEAMB_VHISTRISCSECAOR
VPPRARISCOSMEDCONTROLEAMB.CODCOLIGADA FKVPPRAMEDCONTAMB_VHISTRISSECR
VPPRARISCOSMEIOPROPAGAAMB.CODCOLIGADA FKVPPRAMEIOPROPAMB_VHISTRISSECR
PSECAO.CODCOLIGADA FKVPPRAHISTRISCOSSECAO_PSECAOR
VPPRARISCOS.CODCOLIGADA FKVPPRAHISTRISCOSSECAO_VPPRARIR
CODSECAO varchar 35 null
VPPRARISCOSDANOSAUDEAMB.CODSECAO FKVPPRADANSAUAMB_VHISTRISCOSECR
VPPRARISCOSFONTEGERAAMB.CODSECAO FKVPPRAFONGEAMB_VHISTRISCSECAOR
VPPRARISCOSMEDCONTROLEAMB.CODSECAO FKVPPRAMEDCONTAMB_VHISTRISSECR
VPPRARISCOSMEIOPROPAGAAMB.CODSECAO FKVPPRAMEIOPROPAMB_VHISTRISSECR
PSECAO.CODIGO FKVPPRAHISTRISCOSSECAO_PSECAOR
CODITEMRISCO varchar 10 null
VPPRARISCOSDANOSAUDEAMB.CODITEMRISCO FKVPPRADANSAUAMB_VHISTRISCOSECR
VPPRARISCOSFONTEGERAAMB.CODITEMRISCO FKVPPRAFONGEAMB_VHISTRISCSECAOR
VPPRARISCOSMEDCONTROLEAMB.CODITEMRISCO FKVPPRAMEDCONTAMB_VHISTRISSECR
VPPRARISCOSMEIOPROPAGAAMB.CODITEMRISCO FKVPPRAMEIOPROPAMB_VHISTRISSECR
VPPRARISCOS.CODITEMRISCO FKVPPRAHISTRISCOSSECAO_VPPRARIR
DATA datetime 16,3 null
VPPRARISCOSDANOSAUDEAMB.DATA FKVPPRADANSAUAMB_VHISTRISCOSECR
VPPRARISCOSFONTEGERAAMB.DATA FKVPPRAFONGEAMB_VHISTRISCSECAOR
VPPRARISCOSMEDCONTROLEAMB.DATA FKVPPRAMEDCONTAMB_VHISTRISSECR
VPPRARISCOSMEIOPROPAGAAMB.DATA FKVPPRAMEIOPROPAMB_VHISTRISSECR
DATASAIDA datetime 16,3 √ null
CODTIPOEXPOSICAO varchar 3 √ null
VTIPOEXPOSICAO.CODTIPOEXPOSICAO FKVPPRAHISTRISCSEC_VTIPOEXPOSIR
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)
PKVPPRAHISTRISCOSSECAO Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODSECAO + CODITEMRISCO + DATA

Relationships

Close relationships within degrees of separation