UGRADEPRE

29 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
UGRADE.CODCOLIGADA FKUGRADEPRE_UGRADEPR
CODCUR int 4 null
UGRADE.CODCUR FKUGRADEPRE_UGRADER
CODPER int 4 null
UGRADE.CODPER FKUGRADEPRE_UGRADEPR
GRADE int 4 null
UGRADE.GRADE FKUGRADEPRE_UGRADER
PERIODO int 4 null
CODMAT varchar 16 null
UGRADE.CODMAT FKUGRADEPRE_UGRADER
CODMATPRE varchar 16 null
UGRADE.CODMAT FKUGRADEPRE_UGRADEPR
PRECO char 1 √ 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)
PKUGRADEPRE Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODCUR + CODPER + GRADE + PERIODO + CODMAT + CODMATPRE

Relationships

Close relationships within degrees of separation