SPSLOCAL

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDPREDIO int 4 null
SPSLOCALPS.IDPREDIO FKSPSLOCALPS_SPSLOCALR
SPSPREDIO.IDPREDIO FKSPSLOCAL_SPSPREDIOR
IDLOCAL smallint 2 null
SPSLOCALPS.IDLOCAL FKSPSLOCALPS_SPSLOCALR
IDTIPOLOCAL smallint 2 null
SPSTIPOLOCAL.IDTIPOLOCAL FKSPSLOCAL_SPSTIPOLOCALR
IDENTIFICACAO varchar 30 null
LUGARESVERTICAL smallint 2 √ null
LUGARESHORIZONTAL smallint 2 √ null
NUMEROCANHOTOS smallint 2 √ null
ANDAR smallint 2 √ null
IDENTIFICACAOANDAR varchar 60 √ null
SUPORTADEFAUDITIVA BOOLEAN 1 ('F')
SUPORTADEFVISUAL BOOLEAN 1 ('F')
SUPORTADEFFISICA BOOLEAN 1 ('F')
SUPORTADEFMULTIPLA BOOLEAN 1 ('F')
SUPORTADEFOUTRAS BOOLEAN 1 ('F')
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
SUPORTADEFFALA BOOLEAN 1 ('F')
SUPORTADEFMENTAL BOOLEAN 1 ('F')
SUPORTADEFINTELECTUAL BOOLEAN 1 ('F')
SUPORTABRPDH BOOLEAN 1 ('F')
PROVAFACILKEY varchar 64 √ null
PROVAFACILKEYANDAR varchar 64 √ null
LOCALPROVAONLINE varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSPSLOCAL Primary key Asc/Asc IDPREDIO + IDLOCAL

Relationships

Close relationships within degrees of separation