HPROSPECTCONTATO

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
HEVENTOS.CODCOLIGADAPRO FKHEVENTOS_HPROSPECTCONTATOR
HPROSPECTCONTATOCOMPL.CODCOLIGADA FKHPROSPCONTCOMPL_HPROSPTCONTR
HPROSPECT.CODCOLIGADA FKHPROSPECTCONTATO_HPROSPECTR
CODPROSPECTCONTATO int 4 null
HEVENTOS.CODPROSPECTCONTATO FKHEVENTOS_HPROSPECTCONTATOR
HPROSPECTCONTATOCOMPL.CODPROSPECTCONTATO FKHPROSPCONTCOMPL_HPROSPTCONTR
CODPROSPECT int 4 null
HEVENTOS.CODPROSPECT FKHEVENTOS_HPROSPECTCONTATOR
HPROSPECTCONTATOCOMPL.CODPROSPECT FKHPROSPCONTCOMPL_HPROSPTCONTR
HPROSPECT.CODPROSPECT FKHPROSPECTCONTATO_HPROSPECTR
NOME varchar 50 null
EMAIL varchar 80 √ null
TELEFONE varchar 15 √ null
RAMAL varchar 6 √ null
FAX varchar 15 √ null
FUNCAO varchar 50 √ null
OBSERVACAO varchar 2000 √ null
CODUSUARIO varchar 20 √ null
RUA varchar 100 √ null
NUMERO varchar 8 √ null
COMPLEMENTO DCOMPLEMENTO 60 √ null
BAIRRO DBAIRRO 80 √ null
CODETD varchar 2 √ null
GMUNICIPIO.CODETDMUNICIPIO FKHPROSPECTCONT_GMUNICIPIOR
GETD.CODETD FKHPROSPECTCONTATO_GETDR
CEP DCEP 9 √ null
CELULAR varchar 13 √ null
IDPAIS smallint 2 √ null
GPAIS.IDPAIS FKHPROSPECTCONTATO_GPAISR
CODMUNICIPIO varchar 20 √ null
GMUNICIPIO.CODMUNICIPIO FKHPROSPECTCONT_GMUNICIPIOR
CODUSUARIOONLINE varchar 20 √ null
GUSUARIO.CODUSUARIO FKHPROSPECTCONTATO_GUSUARIOR
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)
PKHPROSPECTCONTATO Primary key Asc/Asc/Asc CODCOLIGADA + CODPROSPECTCONTATO + CODPROSPECT

Relationships

Close relationships within degrees of separation