AABONO

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
AABONFUN.CODCOLIGADA FKAABONFUN_AABONOR
AABONFUNAM.CODCOLIGADA FKAABONFUNAM_AABONOR
AABONFUTURO.CODCOLIGADA FKAABONFUTURO_AABONOR
AABONOFUNCIONARIO.CODCOLIGADA FKAABONOFUNCIONARIO_AABONOR
AFUNREL.CODCOLIGADA FKAFUNREL_AABONOR
VABONOTPATESTADO.CODCOLIGADA FKVABONOTPATESTADO_AABONOR
GCOLIGADA.CODCOLIGADA FKAABONO_GCOLIGADAR
PEVENTO.CODCOLIGADA FKAABONO_PEVENTOR
CODIGO varchar 4 null
AABONFUN.CODABONO FKAABONFUN_AABONOR
AABONFUNAM.CODABONO FKAABONFUNAM_AABONOR
AABONFUTURO.CODABONO FKAABONFUTURO_AABONOR
AABONOFUNCIONARIO.CODABONO FKAABONOFUNCIONARIO_AABONOR
AFUNREL.CODABONO FKAFUNREL_AABONOR
VABONOTPATESTADO.CODABONO FKVABONOTPATESTADO_AABONOR
DESCRICAO varchar 30 null
CODEVE varchar 4 √ null
PEVENTO.CODIGO FKAABONO_PEVENTOR
INCLUIHORASTRAB smallint 2 √ null
TIPOABONODSR smallint 2 √ null
LIMDIASABONO int 4 √ null
PERIODO int 4 √ null
DATAINICIO datetime 16,3 √ null
PFHSTGRADEREMUN.DATAINICIO Implied ConstraintR
ATIVOPORTAL DLOGICO 2 (1)
ID int identity 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CONSIDERALIMITEABONO smallint 2 √ null
HORASABONO int 4 √ null
ATESTADOOBRIGATORIO smallint 2 √ ((0))

Indexes

Constraint Name Type Sort Column(s)
PKAABONO Primary key Asc/Asc CODCOLIGADA + CODIGO
AXAABONO Performance Asc/Asc CODCOLIGADA + DESCRICAO
AXABONOID Must be unique Asc ID

Relationships

Close relationships within degrees of separation