SSERIEHISTORICO

11 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SALUNO.CODCOLIGADA FKSALUNO_SSERIEHISTORICOR
SGRUPOSERIE.CODCOLIGADA FKSGRUPOSERIE_SSERIEHISTORICOR
SHABILITACAO.CODCOLIGADA FKSHABILITACAO_SSERIEHISTORICOR
SHISTALUNOCOL.CODCOLIGADA FKSHISTALUNCOL_SSERIEHISTORICOR
SSERIEHISTORICOTRANSF.CODCOLIGADADESTINO FKSSERIEHISTORICOTRANSF_SSERI2R
SSERIEHISTORICOTRANSF.CODCOLIGADAORIGEM FKSSERIEHISTORICOTRANSF_SSERIR
STIPOCURSO.CODCOLIGADA FKSSERIEHISTORICO_STIPOCURSOR
SCURSOHISTORICO.CODCOLIGADA FKSSERIEHIST_SCURSOHISTORICOR
CODCURSOHIST varchar 10 null
SALUNO.CODCURSOHIST FKSALUNO_SSERIEHISTORICOR
SGRUPOSERIE.CODCURSOHIST FKSGRUPOSERIE_SSERIEHISTORICOR
SHABILITACAO.CODCURSOHIST FKSHABILITACAO_SSERIEHISTORICOR
SHISTALUNOCOL.CODCURSOHIST FKSHISTALUNCOL_SSERIEHISTORICOR
SSERIEHISTORICOTRANSF.CODCURSOHISTDESTINO FKSSERIEHISTORICOTRANSF_SSERI2R
SSERIEHISTORICOTRANSF.CODCURSOHISTORIGEM FKSSERIEHISTORICOTRANSF_SSERIR
SCURSOHISTORICO.CODCURSOHIST FKSSERIEHIST_SCURSOHISTORICOR
CODSERIEHIST int 4 null
SALUNO.CODSERIEHIST FKSALUNO_SSERIEHISTORICOR
SGRUPOSERIE.CODSERIEHIST FKSGRUPOSERIE_SSERIEHISTORICOR
SHABILITACAO.CODSERIEHIST FKSHABILITACAO_SSERIEHISTORICOR
SHISTALUNOCOL.CODSERIEHIST FKSHISTALUNCOL_SSERIEHISTORICOR
SSERIEHISTORICOTRANSF.CODSERIEHISTDESTINO FKSSERIEHISTORICOTRANSF_SSERI2R
SSERIEHISTORICOTRANSF.CODSERIEHISTORIGEM FKSSERIEHISTORICOTRANSF_SSERIR
NOME varchar 60 null
ORDEM int 4 √ null
TEXTOCONCLUSAO varchar 255 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODTIPOCURSO smallint 2 √ null
STIPOCURSO.CODTIPOCURSO FKSSERIEHISTORICO_STIPOCURSOR

Indexes

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

Relationships

Close relationships within degrees of separation