DCAMPOSDIPJ

7308 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DCONTDIPJ.CODCOLIGADA FKDCONTDIPJ_DCAMPOSDIPJR
DFICHASDIPJ.CODCOLIGADA FKDCAMPOSDIPJ_DFICHASDIPJR
DTRIBUTO.CODCOLIGADA FKDCAMPOSDIPJ_DTRIBUTOR
IDCAMPO int 4 null
DCONTDIPJ.IDCAMPO FKDCONTDIPJ_DCAMPOSDIPJR
IDFICHA int 4 null
DFICHASDIPJ.IDFICHA FKDCAMPOSDIPJ_DFICHASDIPJR
COLUNA smallint 2 null
ORDEM smallint 2 null
DESCRICAO varchar 200 √ null
TAMANHO smallint 2 null
FORMATO varchar 1 null
ORIGEM varchar 1 √ null
CODTRBORIGEM varchar 10 √ null
DTRIBUTO.CODTRB FKDCAMPOSDIPJ_DTRIBUTOR
CAMPOORIGEM varchar 30 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKDCAMPOSDIPJ Primary key Asc/Asc IDCAMPO + CODCOLIGADA
DXCAMPOSDIPJ Performance Asc/Asc/Asc/Asc CODCOLIGADA + IDFICHA + COLUNA + ORDEM

Relationships

Close relationships within degrees of separation