ETIPOOCOR

18 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GRUPOOCOR int 4 null
EALUOCOR.CODGRPOCOR FKEALUOCOR_ETIPOOCORR
EPROFOCOR.CODGRPOCOR FKEPROFOCOR_ETIPOOCORR
EGRPOCOR.CODGRPOCOR FKETIPOOCOR_EGRPOCORR
CODTIPOCOR int 4 null
EALUOCOR.CODOCORRENCIA FKEALUOCOR_ETIPOOCORR
EPROFOCOR.CODOCORRENCIA FKEPROFOCOR_ETIPOOCORR
DESCTIPOOCOR varchar 40 √ null
COD_BMP int 4 √ null
DISPONIVELWEB smallint 2 √ 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)
PKETIPOOCOR Primary key Asc/Asc GRUPOOCOR + CODTIPOCOR
OCORRENCIA Performance Asc DESCTIPOOCOR
TIPOOCORRENCIA Performance Asc/Asc GRUPOOCOR + DESCTIPOOCOR

Relationships

Close relationships within degrees of separation