SBLOCO

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SALOCACAOPRIORIDADE.CODCOLIGADA FKSALOCACAOPRIORIDADE_SBLOCOR
SBLOCOCOMPL.CODCOLIGADA FKSBLOCOCOMPL_SBLOCOR
SSALA.CODCOLIGADA FKSSALA_SBLOCOR
SPREDIO.CODCOLIGADA FKSBLOCO_SPREDIOR
CODFILIAL smallint 2 null
SALOCACAOPRIORIDADE.CODFILIAL FKSALOCACAOPRIORIDADE_SBLOCOR
SBLOCOCOMPL.CODFILIAL FKSBLOCOCOMPL_SBLOCOR
SSALA.CODFILIAL FKSSALA_SBLOCOR
SPREDIO.CODFILIAL FKSBLOCO_SPREDIOR
CODPREDIO varchar 5 null
SALOCACAOPRIORIDADE.CODPREDIO FKSALOCACAOPRIORIDADE_SBLOCOR
SBLOCOCOMPL.CODPREDIO FKSBLOCOCOMPL_SBLOCOR
SSALA.CODPREDIO FKSSALA_SBLOCOR
SPREDIO.CODPREDIO FKSBLOCO_SPREDIOR
CODBLOCO varchar 5 null
SALOCACAOPRIORIDADE.CODBLOCO FKSALOCACAOPRIORIDADE_SBLOCOR
SBLOCOCOMPL.CODBLOCO FKSBLOCOCOMPL_SBLOCOR
SSALA.CODBLOCO FKSSALA_SBLOCOR
DESCRICAO varchar 50 √ null
OBSERVACAO MEMO 2147483647 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
LATITUDE DVALOR 8 √ null
LONGITUDE DVALOR 8 √ null
ALTITUDE DVALOR 8 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSBLOCO Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODFILIAL + CODPREDIO + CODBLOCO

Relationships

Close relationships within degrees of separation