AAFDT

26393 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
ABATFUN.CODCOLIGADA FKABATFUN_AAFDTR
ABATFUNAM.CODCOLIGADA FKABATFUNAM_AAFDTR
ID int 4 null
ABATFUN.IDAAFDT FKABATFUN_AAFDTR
ABATFUNAM.IDAAFDT FKABATFUNAM_AAFDTR
NSR int 4 √ null
PIS varchar 11 √ null
CHAPA DCHAPA 16 √ null
DATAHORA DDATE 16,3 √ null
IDIMPORTACAO int 4 √ null
TIPO varchar 1 null
DESCONSIDERADA DLOGICO 2 null
LINHAORIGINAL varchar 170 √ null
CRC int 4 √ null
JUSTIFICATIVA varchar 100 √ null
CODUSUARIO varchar 20 √ null
PROCESSO int 4 √ null
DATAHORAALTERACAO DDATE 16,3 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DISPOSITIVO varchar 2048 √ null
CPF varchar 12 √ null
CPFPIS varchar 12 √ null
CONVCOLETIVA varchar 17 √ null
CODCOLIGADAIMPORT DCODCOLIGADANULL 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKAAFDT Primary key Asc/Asc CODCOLIGADA + ID
AXAAFDT Performance Asc/Asc/Asc CODCOLIGADA + CHAPA + DATAHORA
IDX_AAFDT_AHSTIMPORTACAO Performance Asc/Asc CODCOLIGADAIMPORT + IDIMPORTACAO
IDX_AAFDT_IDIMPORTACAO Performance Asc IDIMPORTACAO

Relationships

Close relationships within degrees of separation