SHISTDISCFACEXT

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SHISTDISCFACEXTPROF.CODCOLIGADA FKSHISTDISCFACEXTPROF_SHISTDISR
SHISTDISCFAC.CODCOLIGADA FKSHISTDISCFACEXT_SHISTDISCFACR
SSTATUS.CODCOLIGADA FKSHISTDISCFACEXT_SSTATUSR
RA varchar 20 null
SHISTDISCFACEXTPROF.RA FKSHISTDISCFACEXTPROF_SHISTDISR
SHISTDISCFAC.RA FKSHISTDISCFACEXT_SHISTDISCFACR
CODDISC varchar 20 null
SHISTDISCFACEXTPROF.CODDISC FKSHISTDISCFACEXTPROF_SHISTDISR
SHISTDISCFAC.CODDISC FKSHISTDISCFACEXT_SHISTDISCFACR
IDPERLET int 4 null
SHISTDISCFACEXTPROF.IDPERLET FKSHISTDISCFACEXTPROF_SHISTDISR
SHISTDISCFAC.IDPERLET FKSHISTDISCFACEXT_SHISTDISCFACR
IDHABILITACAOFILIAL int 4 null
SHISTDISCFACEXTPROF.IDHABILITACAOFILIAL FKSHISTDISCFACEXTPROF_SHISTDISR
SHISTDISCFAC.IDHABILITACAOFILIAL FKSHISTDISCFACEXT_SHISTDISCFACR
IDHISTDISCFACEXT int 4 null
SHISTDISCFACEXTPROF.IDHISTDISCFACEXT FKSHISTDISCFACEXTPROF_SHISTDISR
ANOSEMESTREEXT varchar 16 null
CODDISCEXT varchar 16 null
NOMEDISC varchar 150 null
CODSTATUS int 4 null
SSTATUS.CODSTATUS FKSHISTDISCFACEXT_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
CODINST int 4 √ null
SINSTITUICAO.CODINST FKSHISTDISCFACEXT_SINSTITUICAOR
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)
PKSHISTDISCFACEXT Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + RA + CODDISC + IDPERLET + IDHABILITACAOFILIAL + IDHISTDISCFACEXT

Relationships

Close relationships within degrees of separation