SHISTDISCCOL

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SAREACONHECIMENTOHISTDISCCOL.CODCOLIGADA FKSAREACONHECIMENTOHISTDISCCOR
SDISCIPLINAHIST.CODCOLIGADA FKSHISTDISCCOL_SDISCIPLINAHISTR
SITINERARIOFORMATIVOHIST.CODCOLIGADA FKSHISTDISCCOL_SITINERARIOFORR
SPARTEHIST.CODCOLIGADA FKSHISTDISCCOL_SPARTEHISTR
SSTATUS.CODCOLIGADA FKSHISTDISCCOL_SSTATUSR
SHISTALUNOCOL.CODCOLIGADA FKSHISTDISCCOL_SHISTALUNOCOLR
CODDISCHIST varchar 20 null
SAREACONHECIMENTOHISTDISCCOL.CODDISCHIST FKSAREACONHECIMENTOHISTDISCCOR
SDISCIPLINAHIST.CODDISCHIST FKSHISTDISCCOL_SDISCIPLINAHISTR
RA varchar 20 null
SAREACONHECIMENTOHISTDISCCOL.RA FKSAREACONHECIMENTOHISTDISCCOR
SHISTALUNOCOL.RA FKSHISTDISCCOL_SHISTALUNOCOLR
ANO varchar 10 null
SAREACONHECIMENTOHISTDISCCOL.ANO FKSAREACONHECIMENTOHISTDISCCOR
SHISTALUNOCOL.ANO FKSHISTDISCCOL_SHISTALUNOCOLR
CODCURSOHIST varchar 10 null
SAREACONHECIMENTOHISTDISCCOL.CODCURSOHIST FKSAREACONHECIMENTOHISTDISCCOR
SHISTALUNOCOL.CODCURSOHIST FKSHISTDISCCOL_SHISTALUNOCOLR
CODSERIEHIST int 4 null
SAREACONHECIMENTOHISTDISCCOL.CODSERIEHIST FKSAREACONHECIMENTOHISTDISCCOR
SHISTALUNOCOL.CODSERIEHIST FKSHISTDISCCOL_SHISTALUNOCOLR
CODPARTEHIST varchar 4 null
SAREACONHECIMENTOHISTDISCCOL.CODPARTEHIST FKSAREACONHECIMENTOHISTDISCCOR
SPARTEHIST.CODPARTEHIST FKSHISTDISCCOL_SPARTEHISTR
FALTAS varchar 8 √ null
NOTA varchar 10 √ null
POSICAO int 4 √ null
ECFGAUTEN.POSICAO Implied ConstraintR
CARGAHORARIA varchar 8 √ null
CODSTATUS int 4 √ null
SSTATUS.CODSTATUS FKSHISTDISCCOL_SSTATUSR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODITINERARIOFORMATIVOHIST int 4 √ null
SITINERARIOFORMATIVOHIST.CODITINERARIOFORMATIVOHIST FKSHISTDISCCOL_SITINERARIOFORR

Indexes

Constraint Name Type Sort Column(s)
PKSHISTDISCCOL Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODDISCHIST + CODPARTEHIST + RA + ANO + CODCURSOHIST + CODSERIEHIST
IXSHISTDISCCOL_CURSOHIST Performance Asc/Asc/Asc/Asc CODCOLIGADA + RA + CODCURSOHIST + CODSERIEHIST

Relationships

Close relationships within degrees of separation