GCOMPROMISSO

18 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GAGENDA.CODCOLIGADA FKGAGENDA_GCOMPROMISSOR
VCOMPAUDIENCIAS.CODCOLIGADA FKVCOMPAUDIENCIAS_GCOMPROMISSOR
VCOMPINTIMACOES.CODCOLIGADA FKVCOMPINTIMACOES_GCOMPROMISSOR
GFORMULA.CODCOLIGADA FKGCOMPROMISSO_GFORMULAR
CODSISTEMA varchar 1 null
GAGENDA.CODSISTEMA FKGAGENDA_GCOMPROMISSOR
VCOMPAUDIENCIAS.CODSISTEMA FKVCOMPAUDIENCIAS_GCOMPROMISSOR
VCOMPINTIMACOES.CODSISTEMA FKVCOMPINTIMACOES_GCOMPROMISSOR
GFORMULA.APLICACAO FKGCOMPROMISSO_GFORMULAR
CODUSUARIO varchar 20 null
GAGENDA.CODUSUARIO FKGAGENDA_GCOMPROMISSOR
VCOMPAUDIENCIAS.CODUSUARIO FKVCOMPAUDIENCIAS_GCOMPROMISSOR
VCOMPINTIMACOES.CODUSUARIO FKVCOMPINTIMACOES_GCOMPROMISSOR
ID int 4 null
GAGENDA.COMPROMISSOID FKGAGENDA_GCOMPROMISSOR
VCOMPAUDIENCIAS.ID FKVCOMPAUDIENCIAS_GCOMPROMISSOR
VCOMPINTIMACOES.ID FKVCOMPINTIMACOES_GCOMPROMISSOR
DESCRICAO varchar 60 √ null
DETALHE MEMO 2147483647 √ null
MENSAGEM MEMO 2147483647 √ null
AVISAR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
AVISARUSUARIOS smallint 2 √ null
AVISARINDCOLIGADA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DIASANTECAVISO smallint 2 √ null
TIPOAVISO smallint 2 √ null
PERIODICIDADE smallint 2 √ null
DATAINICIAL datetime 16,3 √ null
DATAFINAL datetime 16,3 √ null
INCREMENTO smallint 2 √ null
DIASSEMANA char 7 √ null
DIA smallint 2 √ null
SEMANA smallint 2 √ null
MES smallint 2 √ null
NOMEITEMMENU varchar 60 √ null
CODFORMULA varchar 8 √ null
GFORMULA.CODIGO FKGCOMPROMISSO_GFORMULAR
ENVIARPARA varchar 255 √ null
HORAINICIAL datetime 16,3 √ null
HORAFINAL datetime 16,3 √ null
GLOBAL BOOLEAN 1 ('F')
DIAINTEIRO DLOGICO 2 √ null
RECORRENCIA text 2147483647 √ null
ROTULO smallint 2 √ null
LOCAL text 2147483647 √ null
STATUS smallint 2 √ null
TIPO tinyint 1 √ null
ACTION varchar 255 √ null
PARAMETERS varchar 255 √ null
LEMBRETE text 2147483647 √ null
OUTLOOKID MEMO 2147483647 √ null
LIVEID MEMO 2147483647 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DATAULTIMAALTERACAO DDATETIME 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKGCOMPROMISSO Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODSISTEMA + CODUSUARIO + ID
GXDATAINICIAL Performance Asc/Asc DATAINICIAL + ID

Relationships

Close relationships within degrees of separation