VPPRAMEDIDAS

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VMEDIDASPREVENTIVAS.CODCOLIGADA FKVPPRAMEDIDAS_VMEDIDASPREVENTR
VPPRANIVEISRISCO.CODCOLIGADA FKVPPRAMEDIDAS_VPPRANIVEISRISCR
VPPRARISCOS.CODCOLIGADA FKVPPRAMEDIDAS_VPPRARISCOSR
CODMEDIDAPREV varchar 10 null
VMEDIDASPREVENTIVAS.CODMEDIDAPREV FKVPPRAMEDIDAS_VMEDIDASPREVENTR
CODITEMRISCO varchar 10 null
VPPRARISCOS.CODITEMRISCO FKVPPRAMEDIDAS_VPPRARISCOSR
VPPRANIVEISRISCO.CODITEMRISCO FKVPPRAMEDIDAS_VPPRANIVEISRISCR
CODNIVELRISCO varchar 10 √ null
VPPRANIVEISRISCO.CODNIVELRISCO FKVPPRAMEDIDAS_VPPRANIVEISRISCR
DATALIMITE datetime 16,3 √ null
CONTROLE DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PREVENTIVA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CORRETIVA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODIDENT 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)
PKVPPRAMEDIDAS Primary key Asc/Asc CODCOLIGADA + CODIDENT

Relationships

Close relationships within degrees of separation