DFICHASDIPJ

140 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DCAMPOSDIPJ.CODCOLIGADA FKDCAMPOSDIPJ_DFICHASDIPJR
DDIPJ.CODCOLIGADA FKDFICHASDIPJ_DDIPJR
IDFICHA int 4 null
DCAMPOSDIPJ.IDFICHA FKDCAMPOSDIPJ_DFICHASDIPJR
IDDIPJ int 4 null
DDIPJ.IDDIPJ FKDFICHASDIPJ_DDIPJR
CODFICHA varchar 10 null
DESCRICAO varchar 200 √ null
GERAR smallint 2 null
MENSAL smallint 2 √ null
MESINICIAL smallint 2 √ null
MESFINAL smallint 2 √ 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)
PKDFICHASDIPJ Primary key Asc/Asc IDFICHA + CODCOLIGADA
DXFICHASDIPJ Must be unique Asc/Asc/Asc CODCOLIGADA + IDDIPJ + CODFICHA

Relationships

Close relationships within degrees of separation