XPIIMOBILIARIA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 null
XPIEQUIPECORRETOR.IDIMOBILIARIA FKXPIEQUIPECORRETOR_XPIIMOBILR
XPIIMOBILIARIA_EMPREENDIMENTO.IMOBILIARIA_ID FKIMOBILIARIA_EMPREENDIMENTOIMOBILIARIA_ID_IMOBILIARIAR
XPIIMOBILIARIA_USUARIO.IMOBILIARIA_ID FKIMOBILIARIA_USUARIOIMOBILIARIA_ID_IMOBILIARIAC
XPIPROPOSTA.IMOBILIARIA_ID FKPROPOSTAIMOBILIARIA_ID_IMOBILIARIAR
XPIUSUARIO.IMOBILIARIA_ID FKUSUARIOIMOBILIARIA_ID_IMOBILIARIAR
NOME varchar 255 √ null
URL varchar 100 √ null
smallint 2 √ ((1))
RESPONSAVEL_NOME varchar 100 √ null
EPLANILHASEXP.NOME Implied ConstraintR
RESPONSAVEL_CRECI varchar 50 √ null
RESPONSAVEL_EMAIL varchar 50 √ null
LOGRADOURO varchar 100 √ null
NUMERO varchar 10 √ null
COMPLEMENTO varchar 50 √ null
BAIRRO varchar 50 √ null
CIDADE varchar 50 √ null
UF varchar 2 √ null
CEP varchar 8 √ null
PERCENTUAL_COMISSAO RMDVALOR4 17,4 √ null
TELEFONE varchar 15 √ null
CELULAR varchar 15 √ null
CNPJ varchar 14 √ null
NOME_FANTASIA varchar 255 √ null
DATA_VIGENCIA_CRECI datetime 16,3 √ 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)
PKXPIIMOBILIARIA Primary key Asc ID

Relationships

Close relationships within degrees of separation