EGRUPOMOD

293 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODPERLET varchar 6 null
ECURPERLET.CODPERLET FKEGRUPOMOD_ECURPERLETR
EMODCONTR.CODPERLET FKEGRUPOMOD_EMODCONTRR
MODCONT varchar 10 null
EMODCONTR.CODMOD FKEGRUPOMOD_EMODCONTRR
CODCOLIGADA DCODCOLIGADA 2 null
ECURPERLET.CODCOLIGADA FKEGRUPOMOD_ECURPERLETR
CODFILIAL smallint 2 null
ECURPERLET.CODFILIAL FKEGRUPOMOD_ECURPERLETR
CODCUR int 4 null
ECURPERLET.CODCUR FKEGRUPOMOD_ECURPERLETR
CODPER int 4 null
ECURPERLET.CODPER FKEGRUPOMOD_ECURPERLETR
CODTUN int 4 null
ECURPERLET.CODTUN FKEGRUPOMOD_ECURPERLETR
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)
PKEGRUPOMOD Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc CODPERLET + MODCONT + CODCOLIGADA + CODFILIAL + CODCUR + CODPER + CODTUN

Relationships

Close relationships within degrees of separation