SHISTDISCTCC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SHISTHABILITACAOALUNO.CODCOLIGADA FKSHISTDISCTCC_SHISTHABILITALUR
IDHABILITACAOFILIAL int 4 null
SHISTHABILITACAOALUNO.IDHABILITACAOFILIAL FKSHISTDISCTCC_SHISTHABILITALUR
RA varchar 20 null
SHISTHABILITACAOALUNO.RA FKSHISTDISCTCC_SHISTHABILITALUR
CODDISC varchar 20 null
IDTCC int 4 null
CODPERIODO smallint 2 √ null
PLETIVO varchar 10 √ null
DISCIPLINA varchar 150 null
STATUS varchar 30 √ null
NUMCREDITOS numeric 17,4 √ null
NOTA RMDVALOR4 17,4 √ null
CH RMDVALOR4 17,4 √ null
GREQUIV int 4 √ null
CODSTATUS int 4 √ null
FALTAS RMDVALOR4 17,4 √ null
CONCEITO varchar 30 √ null
CODSTATUSMATRICULA int 4 √ null
STATUSMATRICULA varchar 30 √ null
DTMATRICULA DDATETIME 16,3 √ null
IDPERLET int 4 √ null
IDHABFILIALAPROVESTUDOS int 4 √ null
IDTURMADISC int 4 √ null
CHHORA varchar 11 √ null
CONCEITOECTS varchar 10 √ null
TEMA varchar 300 √ null
IDTIPOTCC int 4 √ null
NOMETIPOTCC varchar 60 √ null
IDLINHAPESQUISA int 4 √ null
NOMELINHAPESQUISA varchar 60 √ null
IDSTATUSTCC int 4 √ null
NOMESTATUS varchar 60 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IMAGEINDEX smallint 2 √ null
CHEXTENSAO RMDVALOR4 17,4 √ null
CHINTEGRALIZADA RMDVALOR4 17,4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSHISTDISCTCC Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDHABILITACAOFILIAL + RA + CODDISC + IDTCC

Relationships

Close relationships within degrees of separation