SHABILITACAOFILIAL

19 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FTEMPLATEACORDOHABILITFILIAL.CODCOLIGADA FKFTEMPLATEACHBTFILIAL_SHABILIR
SALTERAPROGRAMAESTUDOS.CODCOLIGADA FKSALTERAPROG_SHABILITACAOFILIR
SASSINATURACONTRATO.CODCOLIGADA FKSASSINATURACONTRATO_SHABILIR
SATIVIDADEGRADE.CODCOLIGADA FKSATIVGRAD_SHABILITACAOFILIALR
SAUTORIZACAOCURSO.CODCOLIGADA FKSAUTCURSO_SHABILITACAOFILIALR
SCOMPONENTECURRICULAR.CODCOLIGADA FKSCOMPCUR_SHABILITACAOFILIALR
SCONCESSAOBOLSAHABFILIAL.CODCOLIGADA FKSCONCBOLSAHABFILIAL_SHABFILIR
SCONTACORRENTE.CODCOLIGADA FKSCONTACOR_SHABILITACAOFILIALR
SCOORDENADOR.CODCOLIGADA FKSCOORDENA_SHABILITACAOFILIALR
SCURSOPROCSEL.CODCOLIGADA FKSCURSOPROCSEL_SHABILITFILIALR
SDESCONTOCOND.CODCOLIGADA FKSDESCONTOCOND_SHABILITACAOFIR
SDOCEXIGIDOS.CODCOLIGADA FKSDOCEXIG_SHABILITACAOFILIALR
SDOCEXIGIDOSFIADOR.CODCOLIGADA FKSDOCEXIGFIADOR_SHABFILIALR
SDOCEXIGIDOSHAB.CODCOLIGADA FKSDOCEXIGIDHAB_SHABILOFILIALR
SEXTINSCRICAOVISITA.CODCOLIGADA FKSEXTINSCVISITA_SHABILFILIALR
SFAIXACRED.CODCOLIGADA FKSFAIXCRED_SHABILITACAOFILIALR
SHABILITACAOALUNO.CODCOLIGADA FKSHABILALUNO_SHABILFILIALORIGR
SHABILITACAOFILIALCAMPUS.CODCOLIGADA FKSHABILTOFLCAMPUS_SHABILTFILR
SHABILITACAOFILIALCONT.CODCOLIGADA FKSHABFILIALCONT_SHABFILIALR
SHABILITACAOFILIALDESCPONTUAL.CODCOLIGADA FKSHABILITACAOFILIALDESC_SHABFR
SHABILITACAOFILIALPL.CODCOLIGADA FKSHABFILIALPL_SHABFILIALR
SHABILITACAOFILIALPROFESSOR.CODCOLIGADA FKSHABFILIALPROF_SHABILITACAOFR
SHABILITACAOFILIALRAT.CODCOLIGADA FKSHABFILIALRAT_SHABFILIALR
SHABMODELOPGTO.CODCOLIGADA FKSHABMODELOPGTO_SHABFILIALR
SHABMODELOPGTOPERIODO.CODCOLIGADA FKSHABMODELOPGTOPERIODO_SHABILR
SITEMCURRICULAR.CODCOLIGADA FKSITEMCUR_SHABILITACAOFILIALR
SMODETAPAHABILITACAO.CODCOLIGADA FKSMODETAPAHAB_SHABFILIALR
SOPCAOCANDIDATO.CODCOLIGADA FKSOPCAOCANDIDATO_SHABILFILIALR
SPLANOFERTAEXECUCAO.CODCOLIGADA FKSPLANOFERTAEXEC_SHABFILIALR
SPODEMANDAEXECUTADA.CODCOLIGADA FKSPODEMANDAEXEC_SHABFILIALR
SPSAREAINTERESSE.CODCOLIGADAHABFILIAL FKSPSAREAINT_SHABILITACAOFILR
SPSPARAMETROSAREAOFERTADA.CODCOLIGADA FKSPSPARAMETROSAREAOFERT_SHABR
SSASALAATENDIMENTOHABILITACAO.CODCOLIGADA FKSHABILITACAOFILIALR
STCCLINHAPESQUISAMATRIZAPLIC.CODCOLIGADA FKSTCCLINPESQMATAPLIC_SHABFILIR
STURMA.CODCOLIGADA FKSTURMA_SHABILITACAOFILIALR
STURMADISC.CODCOLIGADA FKSTURMDISC_SHABILITACAOFILIALR
STUTORALUNO.CODCOLIGADA FKSTUTORALUNO_SHABILITFILIALR
GCCUSTO.CODCOLIGADA FKSHABILITACAOFILIAL_GCCUSTOR
SGRADE.CODCOLIGADA FKSHABILITACAOFILIAL_SGRADER
GDEPTO.CODCOLIGADA FKSHABILITACAOFILIAL_GDEPTOR
SCURSOMEC.CODCOLIGADA FKSHABILITACAOFILIAL_SCURSOMECR
STURNO.CODCOLIGADA FKSHABILITACAOFILIAL_STURNOR
SFILIAL.CODCOLIGADA FKSHABILITACAOFILIAL_SFILIALR
IDHABILITACAOFILIAL int 4 null
FTEMPLATEACORDOHABILITFILIAL.IDHABILITACAOFILIAL FKFTEMPLATEACHBTFILIAL_SHABILIR
SALTERAPROGRAMAESTUDOS.IDHABILITACAOFILIAL FKSALTERAPROG_SHABILITACAOFILIR
SASSINATURACONTRATO.IDHABILITACAOFILIAL FKSASSINATURACONTRATO_SHABILIR
SATIVIDADEGRADE.IDHABILITACAOFILIAL FKSATIVGRAD_SHABILITACAOFILIALR
SAUTORIZACAOCURSO.IDHABILITACAOFILIAL FKSAUTCURSO_SHABILITACAOFILIALR
SCOMPONENTECURRICULAR.IDHABILITACAOFILIAL FKSCOMPCUR_SHABILITACAOFILIALR
SCONCESSAOBOLSAHABFILIAL.IDHABILITACAOFILIAL FKSCONCBOLSAHABFILIAL_SHABFILIR
SCONTACORRENTE.IDHABILITACAOFILIAL FKSCONTACOR_SHABILITACAOFILIALR
SCOORDENADOR.IDHABILITACAOFILIAL FKSCOORDENA_SHABILITACAOFILIALR
SCURSOPROCSEL.IDHABILITACAOFILIAL FKSCURSOPROCSEL_SHABILITFILIALR
SDESCONTOCOND.IDHABILITACAOFILIAL FKSDESCONTOCOND_SHABILITACAOFIR
SDOCEXIGIDOS.IDHABILITACAOFILIAL FKSDOCEXIG_SHABILITACAOFILIALR
SDOCEXIGIDOSFIADOR.IDHABILITACAOFILIAL FKSDOCEXIGFIADOR_SHABFILIALR
SDOCEXIGIDOSHAB.IDHABILITACAOFILIAL FKSDOCEXIGIDHAB_SHABILOFILIALR
SEXTINSCRICAOVISITA.IDHABILITACAOFILIAL FKSEXTINSCVISITA_SHABILFILIALR
SFAIXACRED.IDHABILITACAOFILIAL FKSFAIXCRED_SHABILITACAOFILIALR
SHABILITACAOALUNO.IDHABILITACAOFILIAL FKSHABALUNO_SHABILITACAOFILIALR
SHABILITACAOALUNO.IDHABILITACAOFILIALORIGEM FKSHABILALUNO_SHABILFILIALORIGR
SHABILITACAOFILIALCAMPUS.IDHABILITACAOFILIAL FKSHABILTOFLCAMPUS_SHABILTFILR
SHABILITACAOFILIALCONT.IDHABILITACAOFILIAL FKSHABFILIALCONT_SHABFILIALR
SHABILITACAOFILIALDESCPONTUAL.IDHABILITACAOFILIAL FKSHABILITACAOFILIALDESC_SHABFR
SHABILITACAOFILIALPL.IDHABILITACAOFILIAL FKSHABFILIALPL_SHABFILIALR
SHABILITACAOFILIALPROFESSOR.IDHABILITACAOFILIAL FKSHABFILIALPROF_SHABILITACAOFR
SHABILITACAOFILIALRAT.IDHABILITACAOFILIAL FKSHABFILIALRAT_SHABFILIALR
SHABMODELOPGTO.IDHABILITACAOFILIAL FKSHABMODELOPGTO_SHABFILIALR
SHABMODELOPGTOPERIODO.IDHABILITACAOFILIAL FKSHABMODELOPGTOPERIODO_SHABILR
SITEMCURRICULAR.IDHABILITACAOFILIAL FKSITEMCUR_SHABILITACAOFILIALR
SMODETAPAHABILITACAO.IDHABILITACAOFILIAL FKSMODETAPAHAB_SHABFILIALR
SOPCAOCANDIDATO.IDHABILITACAOFILIAL FKSOPCAOCANDIDATO_SHABILFILIALR
SPLANOFERTAEXECUCAO.IDHABILITACAOFILIAL FKSPLANOFERTAEXEC_SHABFILIALR
SPODEMANDAEXECUTADA.IDHABILITACAOFILIAL FKSPODEMANDAEXEC_SHABFILIALR
SPSAREAINTERESSE.IDHABILITACAOFILIAL FKSPSAREAINT_SHABILITACAOFILR
SPSPARAMETROSAREAOFERTADA.IDHABILITACAOFILIAL FKSPSPARAMETROSAREAOFERT_SHABR
SSASALAATENDIMENTOHABILITACAO.IDHABILITACAOFILIAL FKSHABILITACAOFILIALR
STCCLINHAPESQUISAMATRIZAPLIC.IDHABILITACAOFILIAL FKSTCCLINPESQMATAPLIC_SHABFILIR
STURMA.IDHABILITACAOFILIAL FKSTURMA_SHABILITACAOFILIALR
STURMADISC.IDHABILITACAOFILIAL FKSTURMDISC_SHABILITACAOFILIALR
STUTORALUNO.IDHABILITACAOFILIAL FKSTUTORALUNO_SHABILITFILIALR
CODTURNO int 4 null
STURNO.CODTURNO FKSHABILITACAOFILIAL_STURNOR
CODFILIAL smallint 2 null
SFILIAL.CODFILIAL FKSHABILITACAOFILIAL_SFILIALR
GDEPTO.CODFILIAL FKSHABILITACAOFILIAL_GDEPTOR
CODCURSO varchar 10 null
SGRADE.CODCURSO FKSHABILITACAOFILIAL_SGRADER
CODHABILITACAO varchar 10 null
SGRADE.CODHABILITACAO FKSHABILITACAOFILIAL_SGRADER
CODGRADE varchar 10 null
SGRADE.CODGRADE FKSHABILITACAOFILIAL_SGRADER
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKSHABILITACAOFILIAL_GCCUSTOR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKSHABILITACAOFILIAL_GDEPTOR
ATIVO varchar 1 null
CODTIPOCURSO smallint 2 null
SMISITIPOCURSO.CODTIPOCURSO Implied ConstraintR
EMAILCOORDENACAO varchar 60 √ null
EXCLUIPAGTOCARTAOCREDITO varchar 1 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DECRETOCURSO varchar 2147483647 √ null
DESCRICAOCURSO varchar 2147483647 √ null
DECRETOHABILITACAO varchar 2147483647 √ null
DESCRICAOHABILITACAO varchar 2147483647 √ null
EMAILTCC varchar 60 √ null
IDCURSOMEC int 4 √ null
SCURSOMEC.IDCURSOMEC FKSHABILITACAOFILIAL_SCURSOMECR
DIPLOMAREGISTRADOOUTRAIES varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSHABILITACAOFILIAL Primary key Asc/Asc CODCOLIGADA + IDHABILITACAOFILIAL
IDX_SHABILITACAOFILIAL_SHABILI Performance Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODCURSO + CODGRADE + CODHABILITACAO + CODFILIAL + CODTIPOCURSO
SXHABILITACAOFILIAL Must be unique Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODTURNO + CODFILIAL + CODCURSO + CODHABILITACAO + CODGRADE
SXSHABILITACAOFILIAL Performance Asc/Asc/Asc/Asc CODCOLIGADA + CODCURSO + CODHABILITACAO + CODGRADE

Relationships

Close relationships within degrees of separation