SPROFESSORINSTITUICAOMEC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SPROFESSOR.CODCOLIGADA FKSPROFESSORINSTITUICAOMEC_SPRR
SINSTITUICAOMEC.CODCOLIGADA FKSPROFESSORINSTITUICAOMEC_SINR
CODPROF varchar 10 null
SPROFESSOR.CODPROF FKSPROFESSORINSTITUICAOMEC_SPRR
IDINSTITUICAOMEC int 4 null
SINSTITUICAOMEC.IDINSTITUICAOMEC FKSPROFESSORINSTITUICAOMEC_SINR
ESCOLARIDADE smallint 2 √ null
POSGRADUACAO smallint 2 √ null
ATIVO smallint 2 ((1))
ATIVOEXERCICIO smallint 2 √ null
REGIMETRABALHO smallint 2 √ ((1))
SUBSTITUTO smallint 2 ((0))
VISITANTE smallint 2 √ null
TIPOPGVISITANTE smallint 2 √ null
ENSINOCURSOSEQ smallint 2 ((0))
ENSINOGRADUACAO smallint 2 ((0))
ENSINOGRADUACAOEAD smallint 2 ((0))
ENSINOPOSGRADUACAO smallint 2 ((0))
ENSINOPOSGRADUACAOEAD smallint 2 ((0))
PESQUISA smallint 2 ((0))
EXTENSAO smallint 2 ((0))
GESTAO smallint 2 ((0))
BOLSAPESQUISA smallint 2 ((0))
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSPROFESSORINSTITUICAOMEC Primary key Asc/Asc/Asc CODCOLIGADA + CODPROF + IDINSTITUICAOMEC

Relationships

Close relationships within degrees of separation