DCONTDIPJ

72 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DCONTGERDIPJ.CODCOLIGADA FKDCONTGERDIPJ_DCONTDIPJR
DFAIXACCUSTO.CODCOLIGADA FKDFAIXACCUSTO_DCONTDIPJR
DHISTPDIPJ.CODCOLIGADA FKDHISTPDIPJ_DCONTDIPJR
GDEPTO.CODCOLIGADA FKDCONTDIPJ_GDEPTOR
DCAMPOSDIPJ.CODCOLIGADA FKDCONTDIPJ_DCAMPOSDIPJR
IDCONTDIPJ int 4 null
DCONTGERDIPJ.IDCONTDIPJ FKDCONTGERDIPJ_DCONTDIPJR
DFAIXACCUSTO.IDCONTDIPJ FKDFAIXACCUSTO_DCONTDIPJR
DHISTPDIPJ.IDCONTDIPJ FKDHISTPDIPJ_DCONTDIPJR
IDCAMPO int 4 null
DCAMPOSDIPJ.IDCAMPO FKDCONTDIPJ_DCAMPOSDIPJR
CODCOLCONTA DCODCOLIGADA 2 null
CCONTA.CODCOLIGADA FKDCONTDIPJ_CCONTAR
CODCONTA DCODCONTA 40 null
CCONTA.CODCONTA FKDCONTDIPJ_CCONTAR
TIPO smallint 2 null
TCODIGO.TIPO Implied ConstraintR
DESCRICAO varchar 60 √ null
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKDCONTDIPJ_GDEPTOR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKDCONTDIPJ_GDEPTOR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
OPERACAO varchar 1 √ ((1))

Indexes

Constraint Name Type Sort Column(s)
PKDCONTDIPJ Primary key Asc/Asc IDCONTDIPJ + CODCOLIGADA
DXCONTDIPJ Performance Asc/Asc/Asc/Asc CODCOLIGADA + IDCAMPO + CODCOLCONTA + CODCONTA

Relationships

Close relationships within degrees of separation