ABATFUNAM

149495 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
APORTARIA373.CODCOLIGADA FKABATFUNAM_APORTARIA373R
AAFDT.CODCOLIGADA FKABATFUNAM_AAFDTR
AJORNADACALCULADAAM.CODCOLIGADA FKABATFUNAM_AJORNADACALCULADAAMR
CHAPA DCHAPA 16 null
AJORNADACALCULADAAM.CHAPA FKABATFUNAM_AJORNADACALCULADAAMR
DATA datetime 16,3 null
BATIDA int 4 null
STATUS varchar 1 √ null
NATUREZA smallint 2 √ null
CODIGOTERMCOL varchar 10 √ null
DATAINSERCAO datetime 16,3 √ null
DATAAPROV datetime 16,3 √ null
COLIGADARESP DCODCOLIGADANULL 2 √ null
PFUNC.CODCOLIGADA FKABATFUNAM_PFUNCR
CHAPARESP DCHAPANULL 16 √ null
PFUNC.CHAPA FKABATFUNAM_PFUNCR
DATAREFERENCIA datetime 16,3 √ null
AJORNADACALCULADAAM.DATAREFERENCIA FKABATFUNAM_AJORNADACALCULADAAMR
IDJORNADA int 4 √ null
AJORNADACALCULADAAM.IDJORNADA FKABATFUNAM_AJORNADACALCULADAAMR
IDAAFDT int 4 √ null
AAFDT.ID FKABATFUNAM_AAFDTR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TIPOBATIDA int 4 √ null
NATUREZAALTERADA smallint 2 √ null
IDAPORTARIA373 int 4 √ null
APORTARIA373.ID FKABATFUNAM_APORTARIA373R
DATAREFERENCIAALTERADA smallint 2 ((0))

Indexes

Constraint Name Type Sort Column(s)
PKABATFUNAM Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + DATA + BATIDA
IDX_ABATFUNAM_IDAAFDT Performance Asc IDAAFDT

Relationships

Close relationships within degrees of separation