SPSPREDIO

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDPREDIO int 4 null
SPSLOCAL.IDPREDIO FKSPSLOCAL_SPSPREDIOR
NOME varchar 60 null
RUA varchar 100 √ null
NUMERO varchar 8 √ null
COMPLEMENTO DCOMPLEMENTO 60 √ null
BAIRRO DBAIRRO 80 √ null
CODETDMUNICIPIO varchar 2 √ null
GMUNICIPIO.CODETDMUNICIPIO FKSPSPREDIO_GMUNICIPIOR
GETD.CODETD FKSPSPREDIO_GETDR
CODMUNICIPIO varchar 20 √ null
GMUNICIPIO.CODMUNICIPIO FKSPSPREDIO_GMUNICIPIOR
CEP DCEP 9 √ null
IDPAIS smallint 2 √ null
GPAIS.IDPAIS FKSPSPREDIO_GPAISR
TELEFONE varchar 15 √ null
DDD varchar 4 √ null
FAX varchar 15 √ null
CONTATO varchar 40 √ null
EMAIL varchar 60 √ null
IDCAMPUS int 4 √ null
SPSCAMPUS.IDCAMPUS FKSPSPREDIO_SPSCAMPUSR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
PROVAFACILKEY varchar 64 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSPSPREDIO Primary key Asc IDPREDIO

Relationships

Close relationships within degrees of separation