EPROFOCOR

11 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODPERLET varchar 6 null
CODPROF varchar 10 null
EPROFES.CODPROF FKEPROFOCOR_EPROFESR
DATA datetime 16,3 null
NUMOCORRENCIA int 4 null
CODOCORRENCIA int 4 null
ETIPOOCOR.CODTIPOCOR FKEPROFOCOR_ETIPOOCORR
CODGRPOCOR int 4 √ null
ETIPOOCOR.GRUPOOCOR FKEPROFOCOR_ETIPOOCORR
GRUPO varchar 2 √ null
OBSERVACAO MEMO 2147483647 √ null
USUARIO varchar 20 √ null
STATUS varchar 2 √ null
C varchar 1 √ null
DTALT datetime 16,3 √ null
HRALT datetime 16,3 √ null
ETAPA 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)
PKEPROFOCOR Primary key Asc/Asc/Asc/Asc/Asc CODPERLET + CODPROF + DATA + NUMOCORRENCIA + CODOCORRENCIA
EXCODPROFOCOR Performance Asc CODPROF

Relationships

Close relationships within degrees of separation