SFPPROFESSOR

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
SLANCRH.CODCOLIGADA FKSLANCRH_SFPPROFESSORR
SPROFESSOR.CODCOLIGADA FKSFPPROFESSOR_SPROFESSORR
SSIMULACAOPROTHEUS.CODCOLIGADA FKSFPPROFESSOR_SSIMULACAOPROTHR
CODLOTE varchar 20 null
SLANCRH.CODLOTE FKSLANCRH_SFPPROFESSORR
SSIMULACAOPROTHEUS.CODLOTE FKSFPPROFESSOR_SSIMULACAOPROTHR
CODPROF varchar 10 null
SLANCRH.CODPROF FKSLANCRH_SFPPROFESSORR
SPROFESSOR.CODPROF FKSFPPROFESSOR_SPROFESSORR
CODFILIAL smallint 2 null
SLANCRH.CODFILIAL FKSLANCRH_SFPPROFESSORR
CODTIPOCURSO smallint 2 √ null
SMISITIPOCURSO.CODTIPOCURSO Implied ConstraintR
CODTITULACAO smallint 2 √ null
STITULACAO.CODTITULACAO Implied ConstraintR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKSFPPROFESSOR Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODLOTE + CODPROF + CODFILIAL

Relationships

Close relationships within degrees of separation