AABONFUN

495 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
AABONO.CODCOLIGADA FKAABONFUN_AABONOR
APARFUN.CODCOLIGADA FKAABONFUN_APARFUNR
CHAPA DCHAPA 16 null
APARFUN.CHAPA FKAABONFUN_APARFUNR
DATA datetime 16,3 null
CODABONO varchar 4 null
AABONO.CODIGO FKAABONFUN_AABONOR
HORAINICIO int 4 null
HORAFIM int 4 √ null
DESCONSIDERA smallint 2 √ null
RESPONSAVEL varchar 16 √ null
PFUNC.CHAPA FKAABONFUN_PFUNCRESPR
ABONOFUTURO smallint 2 √ null
COLIGADARESP DCODCOLIGADANULL 2 √ null
PFUNC.CODCOLIGADA FKAABONFUN_PFUNCRESPR
SOLUCAOCONFLITO int 4 √ (1)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
JUSTIFICATIVA varchar 200 √ null

Indexes

Constraint Name Type Sort Column(s)
PKAABONFUN Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + DATA + CODABONO + HORAINICIO

Relationships

Close relationships within degrees of separation