ECOLEGIOS

216 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODINST int 4 null
EGRDCURESC.CODINST FKEGRDCURESC_ECOLEGIOSR
EHISTALUN.CODESTAB FKEHISTALUN_ECOLEGIOSR
UALUCURSO.CODFACTRANSFER FKUALUCURSO_ECOLEGIOSFR
UALUCURSO.COLEGIO2GRAU FKUALUCURSO_ECOLEGIOSR
UALUCURSO.INSTREGDIPLOMA FKUALUCURSO_ECOLEGIOSDIPR
UATVCOMPOFERTA.CODINST FKUATVCOMPOFERTA_ECOLEGIOSR
UHISTMATALUNEXT.CODINST FKUHISTMATALUNEXT_ECOLEGIOSR
NOMEINST varchar 100 √ null
CIDADE varchar 30 √ null
UF varchar 2 √ null
CONV varchar 1 √ null
TIPOCONV int 4 √ null
PAIS varchar 30 √ null
DIRETOR varchar 80 √ null
NOMEFANTASIA varchar 100 √ null
RUA varchar 100 √ null
NUMERO varchar 8 √ null
COMPLEMENTO DCOMPLEMENTO 60 √ null
BAIRRO DBAIRRO 80 √ null
CEP DCEP 9 √ null
TELEFONE1 varchar 15 √ null
TELEFONE2 varchar 15 √ null
TELEFONE3 varchar 15 √ null
TIPOINST varchar 1 √ null
EMAIL varchar 80 √ 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)
PKECOLEGIOS Primary key Asc CODINST
NOMEINS Performance Asc NOMEINST

Relationships

Close relationships within degrees of separation