VASSOCPCMSOPPRA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VPERFIL.CODCOLIGADA FKVASSOCPCMSOPPRA_VPERFILR
VPPRANIVEISRISCO.CODCOLIGADA FKVASSOCPCMSOPPRA_VPPRANIVEISRR
VPPRARISCOS.CODCOLIGADA FKVASSOCPCMSOPPRA_VPPRARISCOSR
VPPRAMEDICOES.CODCOLIGADA FKVASSOCPCMSOPPRA_VPPRAMEDICOER
CODIGO int 4 null
TIPOASSOC char 1 null
CODITEMRISCO varchar 10 √ null
VPPRAMEDICOES.CODITEMRISCO FKVASSOCPCMSOPPRA_VPPRAMEDICOER
VPPRARISCOS.CODITEMRISCO FKVASSOCPCMSOPPRA_VPPRARISCOSR
VPPRANIVEISRISCO.CODITEMRISCO FKVASSOCPCMSOPPRA_VPPRANIVEISRR
CODNIVELRISCO varchar 10 √ null
VPPRANIVEISRISCO.CODNIVELRISCO FKVASSOCPCMSOPPRA_VPPRANIVEISRR
CODRECONHECIMENTO int 4 √ null
VPPRAMEDICOES.IDSEQUENCIAL FKVASSOCPCMSOPPRA_VPPRAMEDICOER
CODPESSOA int 4 √ null
PPESSOA.CODIGO FKVASSOCPCMSOPPRA_PPESSOAR
CODPERFIL varchar 10 null
VPERFIL.CODPERFIL FKVASSOCPCMSOPPRA_VPERFILR
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)
PKVASSOCPCMSOPPRA Primary key Asc/Asc CODCOLIGADA + CODIGO

Relationships

Close relationships within degrees of separation