AABONFUTURO

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VTREINAABONO.CODCOLIGADA FKVTREINAABONO_AABONFUTUROR
PFUNC.CODCOLIGADA FKAABONFUTURO_PFUNCR
AABONO.CODCOLIGADA FKAABONFUTURO_AABONOR
APARFUN.CODCOLIGADA FKAABONFUTURO_APARFUNR
CHAPA DCHAPA 16 null
VTREINAABONO.CHAPA FKVTREINAABONO_AABONFUTUROR
APARFUN.CHAPA FKAABONFUTURO_APARFUNR
PFUNC.CHAPA FKAABONFUTURO_PFUNCR
DATAINICIO datetime 16,3 null
VTREINAABONO.DATA FKVTREINAABONO_AABONFUTUROR
CODABONO varchar 4 null
VTREINAABONO.CODABONO FKVTREINAABONO_AABONFUTUROR
AABONO.CODIGO FKAABONFUTURO_AABONOR
DATAFIM datetime 16,3 √ null
HORAINICIO int 4 null
VTREINAABONO.HORAINICIO FKVTREINAABONO_AABONFUTUROR
HORAFIM int 4 √ null
NUMHORAS int 4 √ null
RESPONSAVEL DCHAPANULL 16 √ null
ATITUDE smallint 2 √ null
DTCADASTRO datetime 16,3 √ null
DESCONSIDERA smallint 2 √ null
CODAPLICACAO varchar 1 √ null
SOLUCAOCONFLITO int 4 √ (1)
ABONAANTESCOMPENSACAO smallint 2 √ (0)
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)
PKAABONFUTURO Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + DATAINICIO + CODABONO + HORAINICIO

Relationships

Close relationships within degrees of separation