AJORNADACALCULADA

3948 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
ABATFUN.CODCOLIGADA FKABATFUN_AJORNADACALCULADAR
AOCORRENCIACALCULADA.CODCOLIGADA FKAOCORCALC_AJORNADACALCULADAR
CHAPA DCHAPA 16 null
ABATFUN.CHAPA FKABATFUN_AJORNADACALCULADAR
AOCORRENCIACALCULADA.CHAPA FKAOCORCALC_AJORNADACALCULADAR
DATAREFERENCIA datetime 16,3 null
ABATFUN.DATAREFERENCIA FKABATFUN_AJORNADACALCULADAR
AOCORRENCIACALCULADA.DATAREFERENCIA FKAOCORCALC_AJORNADACALCULADAR
IDJORNADA int 4 null
ABATFUN.IDJORNADA FKABATFUN_AJORNADACALCULADAR
AOCORRENCIACALCULADA.IDJORNADA FKAOCORCALC_AJORNADACALCULADAR
OCORRENCIACRITICADA DLOGICO 2 null
CODUSUARIOOCORRENCIACRITICADA varchar 50 √ null
MEMORIACALCULO MEMO 2147483647 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
REFERENCIABATIDAALTERADA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0

Indexes

Constraint Name Type Sort Column(s)
PKAJORNADACALCULADA Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + DATAREFERENCIA + IDJORNADA

Relationships

Close relationships within degrees of separation