EGRDMATESC

124 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODINST int 4 null
EGRDCURESC.CODINST FKEGRDMATESC_EGRDCURESCR
CODCUR int 4 null
EGRDCURESC.CODCUR FKEGRDMATESC_EGRDCURESCR
EGRADEHIST.CODCUR FKEGRDMATESC_EMATHISTR
CODPER int 4 null
EGRADEHIST.CODPER FKEGRDMATESC_EMATHISTR
EGRDCURESC.CODPER FKEGRDMATESC_EGRDCURESCR
CODMAT varchar 16 null
EGRADEHIST.CODMAT FKEGRDMATESC_EMATHISTR
APROVEIT varchar 6 √ 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)
PKEGRDMATESC Primary key Asc/Asc/Asc/Asc CODINST + CODCUR + CODPER + CODMAT

Relationships

Close relationships within degrees of separation