DPROCESSOJUDICIAL

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
DCODIGOAJUSTE.CODCOLIGADA FKDCODIGOAJUSTE_DPROCESSOJUDIR
DEVENTOREINF.CODCOLIGADA FKDEVENTOREINF_DPROCESSOJUDICIR
DGUIAPERIODO.CODCOLIGADA FKDGUIAPERIO_DPROCESSOJUDICIALR
DITEMTRIBDISCUTIDOS.CODCOLIGADA FKDITEMTRIBDISCUTIDOS_DPROCESSR
DITEMTRIBDISCUTIDOSHISTORICO.CODCOLIGADA FKDITEMTRIBDISCHIST_DPROCJUDR
DLAFMOVPROCESSOJUD.CODCOLIGADA FKDLAFMOVPROCESSOJUD_DPROCJUDR
DLAFMOVPROCESSOJUDHISTORICO.CODCOLIGADA FKDLAFMOVPROCJUDHIST_DPROCJUDR
DLDC.CODCOLIGADA FKDLDC_DPROCESSOJUDICIALR
DPARTICIPATRIMONIALECF.CODCOLIGADA FKDPARTICIPATRIMONIALECF_DPROCR
DPROCESSOJUDICIALLOG.CODCOLIGADA FKDPROCESSOJUDICIALLOG_DPROCESR
DPROCJUDEVCTRB.CODCOLIGADA FKDPROCJUDEVCTRB_DPROCESSOJUDIR
DTRIBDISCUTIDOSPROCJUDICIAL.CODCOLIGADA FKDTRIBDISCPROC_DPROCESSOJUDR
TITMMOVPROCESSOJUD.CODCOLIGADA FKTITMMOVPROCESSOJUD_DPROCJUDR
GCOLIGADA.CODCOLIGADA FKDPROCESSOJUDICIAL_GCOLIGADAR
IDPROCESSO int 4 null
DCODIGOAJUSTE.IDPROCESSO FKDCODIGOAJUSTE_DPROCESSOJUDIR
DEVENTOREINF.IDPROCESSOJUDICIAL FKDEVENTOREINF_DPROCESSOJUDICIR
DGUIAPERIODO.IDPROCESSO FKDGUIAPERIO_DPROCESSOJUDICIALR
DITEMTRIBDISCUTIDOS.IDPROCESSO FKDITEMTRIBDISCUTIDOS_DPROCESSR
DITEMTRIBDISCUTIDOSHISTORICO.IDPROCESSO FKDITEMTRIBDISCHIST_DPROCJUDR
DLAFMOVPROCESSOJUD.IDPROCESSOREFERENCIADO FKDLAFMOVPROCESSOJUD_DPROCJUDR
DLAFMOVPROCESSOJUDHISTORICO.IDPROCESSOREFERENCIADO FKDLAFMOVPROCJUDHIST_DPROCJUDR
DLDC.IDPROCESSO FKDLDC_DPROCESSOJUDICIALR
DPARTICIPATRIMONIALECF.IDPROCESSO FKDPARTICIPATRIMONIALECF_DPROCR
DPROCESSOJUDICIALLOG.IDPROCESSO FKDPROCESSOJUDICIALLOG_DPROCESR
DPROCJUDEVCTRB.IDPROCESSO FKDPROCJUDEVCTRB_DPROCESSOJUDIR
DTRIBDISCUTIDOSPROCJUDICIAL.IDPROCESSO FKDTRIBDISCPROC_DPROCESSOJUDR
TITMMOVPROCESSOJUD.IDPROCESSOREFERENCIADO FKTITMMOVPROCESSOJUD_DPROCJUDR
NUMERO varchar 30 √ null
DESCRICAO varchar 100 √ null
TIPO smallint 2 √ null
TCODIGO.TIPO Implied ConstraintR
ATIVO smallint 2 √ (1)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
SECAOJUDICIARIA varchar 100 √ null
VARA int 4 √ null
NATUREZAJUDICIAL int 4 √ null
DATASENTENCA DDATETIME 16,3 √ null
TIPOPROCESSO varchar 2 √ null
CODETD varchar 2 √ null
GETD.CODETD Implied ConstraintR
CODMUNICIPIO varchar 20 √ null
TERCEIRO smallint 2 √ null
CODCOLCFO DCODCOLIGADANULL 2 √ null
FCFO.CODCOLIGADA FKDPROCESSOJUDICIAL_FCFOR
CODCFO varchar 25 √ null
FCFO.CODCFO FKDPROCESSOJUDICIAL_FCFOR
INTEGRADOTAF smallint 2 ((0))

Indexes

Constraint Name Type Sort Column(s)
PKDPROCESSOJUDICIAL Primary key Asc/Asc IDPROCESSO + CODCOLIGADA
DXDPROCESSOJUDICIAL Must be unique Asc/Asc CODCOLIGADA + NUMERO

Relationships

Close relationships within degrees of separation