SALUNOMEC

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA smallint 2 null
SALUNO.CODCOLIGADA FKSALUNOMEC_SALUNOR
RA varchar 20 null
SALUNO.RA FKSALUNOMEC_SALUNOR
CODINEPALUNO varchar 20 √ null
NIS varchar 11 √ null
NACIONALIDADE smallint 2 √ null
PAISORIGMEC smallint 2 √ null
ORGEXPEDIDORCI smallint 2 √ null
TRANSPORTEPUB smallint 2 √ (0)
TRANSPGOVERNO smallint 2 √ null
ZONARESIDENCIA smallint 2 √ (1)
EDUEMOUTROESPACO smallint 2 √ (3)
NECESSIDADEESPEC smallint 2 √ (0)
CEGUEIRA smallint 2 √ null
BAIXAVISAO smallint 2 √ null
SURDEZ smallint 2 √ null
DEFAUDITIVA smallint 2 √ null
SURDOCEGUEIRA smallint 2 √ null
DEFFISICA smallint 2 √ null
DEFMENTAL smallint 2 √ null
DEFMULTIPLA smallint 2 √ null
AUTISMO smallint 2 √ null
ASPERGER smallint 2 √ null
RETT smallint 2 √ null
PSICOSEINFANTIL smallint 2 √ null
SUPERDOTADO smallint 2 √ null
RALIMPO varchar 20 √ null
SIGLAPAISORIGMEC varchar 3 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
JUSTFALTADOC smallint 2 √ null
TRPRODVAN smallint 2 √ null
TRPRODMICROBUS smallint 2 √ null
TRPRODBUS smallint 2 √ null
TRPRODBICICLO smallint 2 √ null
TRPRODANIMAL smallint 2 √ null
TRPRODOUTRO smallint 2 √ null
TRPBARCOATE5 smallint 2 √ null
TRPBARCOATE15 smallint 2 √ null
TRPBARCOATE35 smallint 2 √ null
TRPBARCOMAIS35 smallint 2 √ null
TRPFERROVIARIO smallint 2 √ null
TURMAUNIFICADA smallint 2 √ null
TEMAUTODECLABAIXARENDA smallint 2 √ null
TEMATRIBUICAOCOTA smallint 2 √ null
CODTIPOCOTA varchar 3 √ null
PSICOSSOCIAL smallint 2 √ null
PARAPLEGIA smallint 2 √ null
TETRAPLEGIA smallint 2 √ null
HEMIPLEGIA smallint 2 √ null
AMPUTACAO smallint 2 √ null
PARALCEREBRAL smallint 2 √ null
DEFOBSERVACOES MEMO 2147483647 √ null
RECAUXILIOLEDOR smallint 2 √ null
RECAUXILIOTRANSCRICAO smallint 2 √ null
RECGUIAINTERPRETE smallint 2 √ null
RECINTERPRETELIBRAS smallint 2 √ null
RECLEITURALABIAL smallint 2 √ null
RECPROVAAMPLIADAFONTE16 smallint 2 √ null
RECPROVAAMPLIADAFONTE20 smallint 2 √ null
RECPROVAAMPLIADAFONTE24 smallint 2 √ null
RECPROVABRAILLE smallint 2 √ null
RECPROVAAMPLIADAFONTE18 varchar 1 √ null
RECCDAUDIODEFVISUAL varchar 1 √ null
RECPROVAPORTUGUESSEGLINGUA varchar 1 √ null
RECPROVAVIDEOLIBRAS varchar 1 √ null
LOCALIZACAODIFERENCIADA varchar 1 √ null
TGDTEA smallint 2 √ ((0))
TIPOESCOLACONCLUSAOENSINOMEDIO smallint 2 √ ((0))
JUSTIFICATIVA smallint 2 √ null
VISAOMONOCULAR smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSALUNOMEC Primary key Asc/Asc CODCOLIGADA + RA

Relationships

Close relationships within degrees of separation