SPROFESSORFILIAL

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKSPROFESSORFILIAL_PFUNCR
GCOLIGADA.CODCOLIGADA FKSPROFESSORFILIAL_GCOLIGADAR
SPROFESSOR.CODCOLIGADA FKSPROFESSORFILIAL_SPROFESSORR
GFILIAL.CODCOLIGADA FKSPROFESSORFILIAL_GFILIALR
CODFILIAL smallint 2 null
GFILIAL.CODFILIAL FKSPROFESSORFILIAL_GFILIALR
CODPROF varchar 10 null
SPROFESSOR.CODPROF FKSPROFESSORFILIAL_SPROFESSORR
MATRICULAPROTHEUS varchar 6 √ null
CHAPA DCHAPANULL 16 √ null
PFUNC.CHAPA FKSPROFESSORFILIAL_PFUNCR
ATIVO varchar 1 ('S')
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDPROFESSORFILIAL int 4 null

Indexes

Constraint Name Type Sort Column(s)
PKSPROFESSORFILIAL Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODFILIAL + CODPROF + IDPROFESSORFILIAL
SXSPROFESSORFILIAL Must be unique Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODFILIAL + CODPROF + MATRICULAPROTHEUS + CHAPA

Relationships

Close relationships within degrees of separation