SHISTDISCFAC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SHISTDISCFACEXT.CODCOLIGADA FKSHISTDISCFACEXT_SHISTDISCFACR
SHISTDISCFACPROF.CODCOLIGADA FKSHISTDISCFACPROF_SHISTDISCFAR
SHABILITACAOALUNO.CODCOLIGADA FKSHISTDISCFAC_SHABILALUNOR
SSTATUS.CODCOLIGADA FKSHISTDISCFAC_SSTATUSR
SDISCIPLINA.CODCOLIGADA FKSHISTDISCFAC_SDISCIPLINAR
SPLETIVO.CODCOLIGADA FKSHISTDISCFAC_SPLETIVOR
RA varchar 20 null
SHISTDISCFACEXT.RA FKSHISTDISCFACEXT_SHISTDISCFACR
SHISTDISCFACPROF.RA FKSHISTDISCFACPROF_SHISTDISCFAR
SHABILITACAOALUNO.RA FKSHISTDISCFAC_SHABILALUNOR
CODDISC varchar 20 null
SHISTDISCFACEXT.CODDISC FKSHISTDISCFACEXT_SHISTDISCFACR
SHISTDISCFACPROF.CODDISC FKSHISTDISCFACPROF_SHISTDISCFAR
SDISCIPLINA.CODDISC FKSHISTDISCFAC_SDISCIPLINAR
IDPERLET int 4 null
SHISTDISCFACEXT.IDPERLET FKSHISTDISCFACEXT_SHISTDISCFACR
SHISTDISCFACPROF.IDPERLET FKSHISTDISCFACPROF_SHISTDISCFAR
SPLETIVO.IDPERLET FKSHISTDISCFAC_SPLETIVOR
IDHABILITACAOFILIAL int 4 null
SHISTDISCFACEXT.IDHABILITACAOFILIAL FKSHISTDISCFACEXT_SHISTDISCFACR
SHISTDISCFACPROF.IDHABILITACAOFILIAL FKSHISTDISCFACPROF_SHISTDISCFAR
SHABILITACAOALUNO.IDHABILITACAOFILIAL FKSHISTDISCFAC_SHABILALUNOR
CODINST int 4 √ null
SINSTITUICAO.CODINST FKSHISTDISCFAC_SINSTITUICAOR
CODSTATUS int 4 √ null
SSTATUS.CODSTATUS FKSHISTDISCFAC_SSTATUSR
CARGAHORARIA RMDVALOR4 17,4 √ null
NOTA RMDVALOR4 17,4 √ null
FALTAS int 4 √ null
CONCEITO varchar 30 √ null
OBS MEMO 2147483647 √ null
NUMCREDITOS numeric 17,4 √ null
EXCLUSIVO varchar 1 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CONCEITOECTS varchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSHISTDISCFAC Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + RA + CODDISC + IDPERLET + IDHABILITACAOFILIAL
IDX_SHISTDICFAC_RACODDISCIDPER Performance Asc/Asc/Asc/Asc RA + CODDISC + IDPERLET + IDHABILITACAOFILIAL

Relationships

Close relationships within degrees of separation