EGRADEHIST

1965 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCUR int 4 null
EGRDMATESC.CODCUR FKEGRDMATESC_EMATHISTR
EHISTMAT.CODCUR FKEHISTMAT_EMATHISTR
ECURSOHIST.CODCURSOHIST FKEGRADEHIST_ECURSOHISTR
CODPER int 4 null
EGRDMATESC.CODPER FKEGRDMATESC_EMATHISTR
EHISTMAT.CODPER FKEHISTMAT_EMATHISTR
EPERIODOHIST.CODPERIODOHIST FKEGRADEHIST_EPERIODOHISTR
CODMAT varchar 16 null
EGRDMATESC.CODMAT FKEGRDMATESC_EMATHISTR
EHISTMAT.CODMAT FKEHISTMAT_EMATHISTR
EMATHIST.CODMAT FKEGRADEHIST_EMATHISTR
POSHIST int 4 √ null
PARTE varchar 1 √ null
ETABPARTE.CODPARTE FKEGRADEHST_ETABPARTER
CODGRPMATHIST int 4 √ null
EGRPMATHIST.CODGRPMATHIST FKEGRADEHIST_EGRPMATHISTR
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)
PKEGRADEHIST Primary key Asc/Asc/Asc CODCUR + CODPER + CODMAT
EXGRADEHISTMAT Performance Asc/Asc/Asc CODMAT + CODCUR + CODPER

Relationships

Close relationships within degrees of separation