SMATRICPL

351 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SCONTRATO.CODCOLIGADA FKSCONTRATO_SMATRICPLR
SMATRICPLCOMPL.CODCOLIGADA FKSMATRICPLCOMPL_SMATRICPLR
SMATRICPLCOMPLPTG.CODCOLIGADA FKSMATRICPLCOMPLPTG_SMATRICPLR
SMATRICPLITEMCNT.CODCOLIGADA FKSMATRICPLITEMCNT_SMATRICPLR
SMATRICPLITINERARIOFORMATIVO.CODCOLIGADA FKSMATRICPLITFORMAT_SMATRICPLR
SMATRICPLMEC.CODCOLIGADA FKSMATRICPLMEC_SMATRICPLR
SMATRICULA.CODCOLIGADA FKSMATRICULA_SMATRICPLR
SPROTOCOLO.CODCOLIGADA FKSPROTOCOLO_SMATRICPLR
SPSINSCRICAOAREAOFERTADA.CODCOLIGADAMAT FKSPSINSCAREAOFER_SMATRICPLR
SVAGASCANDIDATOSMATRICPL.CODCOLIGADA FKSVAGASCANDIMATRICPL_SMATRICPR
SHABILITACAOALUNO.CODCOLIGADA FKSMATRICPL_SHABILITACAOALUNOR
SMOTIVOALTMAT.CODCOLIGADA FKSMATRICPL_SMOTIVOALTMATR
SPSINSCRICAOAREAOFERTADA.CODCOLIGADA FKSMATRICPL_SPSINSCRICAOAREAOFR
SALUNO.CODCOLIGADA FKSMATRICPL_SALUNOR
STIPOMATRICULA.CODCOLIGADA FKSMATRICPL_STIPOMATRICULAR
STURMA.CODCOLIGADA FKSMATRICPL_STURMAR
SSTATUS.CODCOLIGADA FKSMATRICPL_SSTATUSRESR
SPLETIVO.CODCOLIGADA FKSMATRICPL_SPLETIVOR
IDPERLET int 4 null
SCONTRATO.IDPERLET FKSCONTRATO_SMATRICPLR
SMATRICPLCOMPL.IDPERLET FKSMATRICPLCOMPL_SMATRICPLR
SMATRICPLCOMPLPTG.IDPERLET FKSMATRICPLCOMPLPTG_SMATRICPLR
SMATRICPLITEMCNT.IDPERLET FKSMATRICPLITEMCNT_SMATRICPLR
SMATRICPLITINERARIOFORMATIVO.IDPERLET FKSMATRICPLITFORMAT_SMATRICPLR
SMATRICPLMEC.IDPERLET FKSMATRICPLMEC_SMATRICPLR
SMATRICULA.IDPERLET FKSMATRICULA_SMATRICPLR
SPROTOCOLO.IDPERLET FKSPROTOCOLO_SMATRICPLR
SPSINSCRICAOAREAOFERTADA.IDPERLET FKSPSINSCAREAOFER_SMATRICPLR
SVAGASCANDIDATOSMATRICPL.IDPERLET FKSVAGASCANDIMATRICPL_SMATRICPR
SPLETIVO.IDPERLET FKSMATRICPL_SPLETIVOR
STURMA.IDPERLET FKSMATRICPL_STURMAR
IDHABILITACAOFILIAL int 4 null
SCONTRATO.IDHABILITACAOFILIAL FKSCONTRATO_SMATRICPLR
SMATRICPLCOMPL.IDHABILITACAOFILIAL FKSMATRICPLCOMPL_SMATRICPLR
SMATRICPLCOMPLPTG.IDHABILITACAOFILIAL FKSMATRICPLCOMPLPTG_SMATRICPLR
SMATRICPLITEMCNT.IDHABILITACAOFILIAL FKSMATRICPLITEMCNT_SMATRICPLR
SMATRICPLITINERARIOFORMATIVO.IDHABILITACAOFILIAL FKSMATRICPLITFORMAT_SMATRICPLR
SMATRICPLMEC.IDHABILITACAOFILIAL FKSMATRICPLMEC_SMATRICPLR
SMATRICULA.IDHABILITACAOFILIAL FKSMATRICULA_SMATRICPLR
SPROTOCOLO.IDHABILITACAOFILIAL FKSPROTOCOLO_SMATRICPLR
SPSINSCRICAOAREAOFERTADA.IDHABFILIALMAT FKSPSINSCAREAOFER_SMATRICPLR
SVAGASCANDIDATOSMATRICPL.IDHABILITACAOFILIAL FKSVAGASCANDIMATRICPL_SMATRICPR
SHABILITACAOALUNO.IDHABILITACAOFILIAL FKSMATRICPL_SHABILITACAOALUNOR
RA varchar 20 null
SCONTRATO.RA FKSCONTRATO_SMATRICPLR
SMATRICPLCOMPL.RA FKSMATRICPLCOMPL_SMATRICPLR
SMATRICPLCOMPLPTG.RA FKSMATRICPLCOMPLPTG_SMATRICPLR
SMATRICPLITEMCNT.RA FKSMATRICPLITEMCNT_SMATRICPLR
SMATRICPLITINERARIOFORMATIVO.RA FKSMATRICPLITFORMAT_SMATRICPLR
SMATRICPLMEC.RA FKSMATRICPLMEC_SMATRICPLR
SMATRICULA.RA FKSMATRICULA_SMATRICPLR
SPROTOCOLO.RA FKSPROTOCOLO_SMATRICPLR
SPSINSCRICAOAREAOFERTADA.RAMAT FKSPSINSCAREAOFER_SMATRICPLR
SVAGASCANDIDATOSMATRICPL.RA FKSVAGASCANDIMATRICPL_SMATRICPR
SHABILITACAOALUNO.RA FKSMATRICPL_SHABILITACAOALUNOR
SALUNO.RA FKSMATRICPL_SALUNOR
CODFILIAL smallint 2 √ null
STURMA.CODFILIAL FKSMATRICPL_STURMAR
CODTIPOMAT smallint 2 √ null
STIPOMATRICULA.CODTIPOMAT FKSMATRICPL_STIPOMATRICULAR
CODTURMA varchar 20 √ null
STURMA.CODTURMA FKSMATRICPL_STURMAR
CODSTATUSRES int 4 √ null
SSTATUS.CODSTATUS FKSMATRICPL_SSTATUSRESR
CODSTATUS int 4 null
SSTATUS.CODSTATUS FKSMATRICPL_SSTATUSR
DTMATRICULA datetime 16,3 √ null
DTRESULTADO datetime 16,3 √ null
IDENTIFICADOR varchar 15 √ null
NUMCARTEIRA varchar 20 √ null
VIACARTEIRA varchar 20 √ null
PERIODO int 4 √ null
NUMALUNO int 4 √ null
CARTEIRAEMITIDA varchar 1 √ ('N')
SELINSTENADE varchar 1 √ null
SELMECENADE varchar 1 √ null
DTPROVAENADE datetime 16,3 √ null
COMPARECEUENADE varchar 1 √ null
OBSENADE MEMO 2147483647 √ null
DTSOLICITACAOALTERACAO datetime 16,3 √ null
CR RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODINSTDESTINO int 4 √ null
SINSTITUICAO.CODINST FKSMATRICPL_SINSTITUICAOR
CODMOTIVOTRANSFERENCIA smallint 2 √ null
SMOTIVOALTMAT.CODMOTIVO FKSMATRICPL_SMOTIVOALTMATR
TEMCONTRATOAPRENDIZAGEM varchar 1 √ null
TEMRIP varchar 1 √ null
DTMATRICULAENCERRA DDATETIME 16,3 √ null
IDPS int 4 √ null
SPSINSCRICAOAREAOFERTADA.IDPS FKSMATRICPL_SPSINSCRICAOAREAOFR
NUMEROINSCRICAO int 4 √ null
SPSINSCRICAOAREAOFERTADA.NUMEROINSCRICAO FKSMATRICPL_SPSINSCRICAOAREAOFR
SITUACAOENADE smallint 2 √ null
OUTRASITUACAOENADE varchar 100 √ null
ANOREFERENCIAENADE int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSMATRICPL Primary key Asc/Asc/Asc/Asc CODCOLIGADA + IDPERLET + IDHABILITACAOFILIAL + RA
IXSMATRICPL Performance Asc/Asc CODCOLIGADA + RA

Relationships

Close relationships within degrees of separation