SCAMPUS

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCAMPUS varchar 10 null
SALOCACAOPRIORIDADE.CODCAMPUS FKSALOCACAOPRIORIDADE_SCAMPUSR
SCAMPUS.CODCAMPUSDIPLOMADIGITAL FKSCAMPUS_SCAMPUSR
SCAMPUSMX.CODCAMPUS FKSCAMPUSMX_SCAMPUSR
SCAMPUSPT.CODCAMPUS FKSCAMPUSPT_SCAMPUSR
SCAMPUSRESPONSAVEL.CODCAMPUS FKSCAMPUSRESPONSAVEL_SCAMPUSR
SHABILITACAOFILIALCAMPUS.CODCAMPUS FKSHABILITFILIALCAMPUS_SCAMPUSR
SLISTAESPERAINSTALACAO.CODCAMPUS FKSLISTAESPERAINST_SCAMPUSR
SPSOPCAOINSCRITO.CODCAMPUSMATRICULA FKSPSOPCAOINSCRITO_SCAMPUSR
SRESERVAINSTALACAO.CODCAMPUS FKSRESERVAINSTALACAO_SCAMPUSR
SSOLENIDADE.CODCAMPUS FKSSOLENIDADE_SCAMPUSR
STURMA.CODCAMPUS FKSTURMA_SCAMPUSR
STURMADISC.CODCAMPUS FKSTURMADISC_SCAMPUSR
DESCRICAO varchar 100 null
RUA varchar 140 √ null
NUMERO varchar 8 √ null
COMPLEMENTO DCOMPLEMENTO 60 √ null
BAIRRO DBAIRRO 80 √ null
CIDADE DCIDADE 32 √ null
CEP DCEP 9 √ null
UF varchar 2 √ null
AREATOTAL RMDVALOR2 17,2 √ null
AREAVERDE RMDVALOR2 17,2 √ null
AREACONSTRUIDA RMDVALOR2 17,2 √ null
AREACONSTRUIR RMDVALOR2 17,2 √ null
AREAESTACIONAMENTO RMDVALOR2 17,2 √ null
VAGASESTDEFICIENTES int 4 √ null
ATIVO char 1 √ null
TOTALVAGASEST int 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TIPOCAMPUS smallint 2 √ null
IDPAIS smallint 2 √ null
GPAIS.IDPAIS FKSCAMPUS_GPAISR
CODCFO varchar 25 √ null
CODCOLCFO int 4 √ null
CAMPUSMEC varchar 12 √ null
NUMEROPROCESSO int 4 √ null
TIPOPROCESSO varchar 255 √ null
DATAPROTOCOLO datetime 16,3 √ null
DATACADASTRO datetime 16,3 √ null
CODCAMPUSDIPLOMADIGITAL varchar 10 √ null
SCAMPUS.CODCAMPUS FKSCAMPUS_SCAMPUSR

Indexes

Constraint Name Type Sort Column(s)
PKSCAMPUS Primary key Asc CODCAMPUS

Relationships

Close relationships within degrees of separation