ACOMPFUN

195 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
APERFUN.CODCOLIGADA FKACOMPFUN_APERFUNR
PEVENTO.CODCOLIGADA FKACOMPFUN_PEVENTOR
APARFUN.CODCOLIGADA FKACOMPFUN_APARFUNR
CHAPA DCHAPA 16 null
APARFUN.CHAPA FKACOMPFUN_APARFUNR
APERFUN.CHAPA FKACOMPFUN_APERFUNR
INICIOPER datetime 16,3 null
APERFUN.INICIOPER FKACOMPFUN_APERFUNR
FIMPER datetime 16,3 null
APERFUN.FIMPER FKACOMPFUN_APERFUNR
CODEVE varchar 4 null
PEVENTO.CODIGO FKACOMPFUN_PEVENTOR
ANOCOMP smallint 2 null
MESCOMP smallint 2 null
NUMHORAS int 4 √ null
VALOR RMDVALOR2 17,2 √ null
CALCPORFORMULA smallint 2 √ null
TIPOEVENTO varchar 2 √ 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)
PKACOMPFUN Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + INICIOPER + FIMPER + CODEVE + MESCOMP

Relationships

Close relationships within degrees of separation