EPROFES

82 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODPROF varchar 10 null
EALUOCOR.CODPROF FKEALUOCOR_EPROFESR
EDISPPROF.CODPROF FKEDISPPROF_EPROFESR
EFILHOPR.CODPROF FKEFILHOPR_EPROFESR
EPCOMPL.CODPROF FKEPCOMPL_EPROFESR
EPROFCREDENC.CODPROF FKEPROFCREDENC_EPROFESR
EPROFMATTURMA.CODPROF FKEPROFMATTURMA_EPROFESR
EPROFOCOR.CODPROF FKEPROFOCOR_EPROFESR
EPROFRESPONSAVEL.CODPROF FKEPROFRESPONSAVEL_EPROFESR
EPROFTURMISTA.CODPROF FKEPROFTURMISTA_EPROFESR
UPROFALUNO.CODPROF FKUPROFALUNOEPROFESR
UPROFATIVIDADES.CODPROF FKUPROFATIVIDADESEPROFESR
UPROFATVDOCENTE.CODPROF FKUPROFATVDOCENTE_EPROFESR
UPROFBANCA.CODPROF FKUPROFBANCAEPROFESR
UPROFCAPACITACAO.CODPROF FKUPROFCAPACITACAOEPROFESR
UPROFCREDENC.CODPROF FKUPROFCREDENCEPROFESR
UPROFESSORMEC.CODPROF FKUPROFESSORMEC_EPROFESR
UPROFFORMACAO.CODPROF FKUPROFFORMACAOEPROFESR
UPROFMATTURMA.CODPROF FKUPROFMATTURMA_EPROFESR
UPROFPUBLIC.CODPROF FKUPROFPUBLICEPROFESR
UPROFRESPONSAVEL.CODPROF FKUPROFRESPONSAVEL_EPROFESR
UPROTOCOLOS.CODPROF FKUPROTOCOLOS_EPROFESR
CODPESSOA int 4 null
PPESSOA.CODIGO FKEPROFES_PPESSOAR
NOME varchar 40 √ null
RELIGIAO varchar 3 √ null
CARGO int 4 √ null
FUNCAO varchar 3 √ null
DEPARTAMENTO varchar 25 √ null
ADMISSAO datetime 16,3 √ null
DEMISSAO datetime 16,3 √ null
DTBASE datetime 16,3 √ null
MASP varchar 10 √ null
REGIMETRAB varchar 15 √ null
EXPPROFISSIONAL varchar 15 √ null
CODUSUARIO varchar 20 √ null
GUSUARIO.CODUSUARIO FKEPROFES_GUSUARIOR
CODCOLFUNC DCODCOLIGADANULL 2 √ null
PFUNC.CODCOLIGADA FKEPROFES_PFUNCR
CHAPA DCHAPANULL 16 √ null
PFUNC.CHAPA FKEPROFES_PFUNCR
CODVRAULA int 4 √ null
EVALORAUL.CODIGO FKEPROFES_EVALORAULR
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)
PKEPROFES Primary key Asc CODPROF
EXCMASP Performance Asc MASP
EXNOMEPROF Performance Asc NOME

Relationships

Close relationships within degrees of separation