SHISTALUNOCOL

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SHISTDISCCOL.CODCOLIGADA FKSHISTDISCCOL_SHISTALUNOCOLR
SALUNO.CODCOLIGADA FKSHISTALUNOCOL_SALUNOR
SSERIEHISTORICO.CODCOLIGADA FKSHISTALUNCOL_SSERIEHISTORICOR
SSTATUS.CODCOLIGADA FKSHISTALUNOCOL_SSTATUSR
RA varchar 20 null
SHISTDISCCOL.RA FKSHISTDISCCOL_SHISTALUNOCOLR
SALUNO.RA FKSHISTALUNOCOL_SALUNOR
ANO varchar 10 null
SHISTDISCCOL.ANO FKSHISTDISCCOL_SHISTALUNOCOLR
CODCURSOHIST varchar 10 null
SHISTDISCCOL.CODCURSOHIST FKSHISTDISCCOL_SHISTALUNOCOLR
SSERIEHISTORICO.CODCURSOHIST FKSHISTALUNCOL_SSERIEHISTORICOR
CODSERIEHIST int 4 null
SHISTDISCCOL.CODSERIEHIST FKSHISTDISCCOL_SHISTALUNOCOLR
SSERIEHISTORICO.CODSERIEHIST FKSHISTALUNCOL_SSERIEHISTORICOR
CODINST int 4 √ null
SINSTITUICAO.CODINST FKSHISTALUNOCOL_SINSTITUICAOR
CODSTATUS int 4 √ null
SSTATUS.CODSTATUS FKSHISTALUNOCOL_SSTATUSR
DIASLETIVOS int 4 √ null
CARGAHORARIA varchar 16 √ null
OBS MEMO 2147483647 √ null
MINAPROV RMDVALOR4 17,4 √ null
DIRETOR varchar 60 √ null
FALTAS varchar 10 √ null
PERCENTFREQ RMDVALOR4 17,4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
MINAPROVCONCEITO varchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSHISTALUNOCOL Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + RA + ANO + CODCURSOHIST + CODSERIEHIST

Relationships

Close relationships within degrees of separation