VEMAIL

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODEMAIL varchar 10 null
VADAVALIACAO.CODEMAILCONSENSUAL FKVADAVALIACAO_VEMAILEMAILCONSR
VADAVALIACAO.CODEMAILEXECUCAO FKVADAVALIACAO_VEMAILEMAILEXECR
VEMAILIMAGEM.CODEMAIL FKVEMAILIMAGEM_VEMAILR
VREQTIPO.CODEMAILREQAPROVADA FKVREQTIPO_VEMAILR
VREQTIPO.CODEMAILREQCANCELADA FKVREQTIPO_VEMAIL3R
VREQTIPO.CODEMAILREQEFETIVADA FKVREQTIPO_VEMAIL4R
VREQTIPO.CODEMAILREQENCAMINHADA FKVREQTIPO_VEMAIL6R
VREQTIPO.CODEMAILREQREPROVADA FKVREQTIPO_VEMAIL2R
CODCOLIGADA smallint 2 null
VADAVALIACAO.CODCOLIGADA FKVADAVALIACAO_VEMAILEMAILEXECR
VEMAILIMAGEM.CODCOLIGADA FKVEMAILIMAGEM_VEMAILR
VREQTIPO.CODCOLIGADA FKVREQTIPO_VEMAIL4R
GCOLIGADA.CODCOLIGADA FKVEMAIL_GCOLIGADAR
ASSUNTO varchar 100 null
TEXTORTF varchar 2147483647 √ null
TEXTOHTML varchar 2147483647 √ null
CODRELATORIO varchar 30 √ null
GERAREMHTML smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TEXTOREDESOCIAL varchar 2147483647 √ null
TIPO int 4 null

Indexes

Constraint Name Type Sort Column(s)
PKVEMAIL Primary key Asc/Asc CODEMAIL + CODCOLIGADA

Relationships

Close relationships within degrees of separation