PFMOVENSINOIMP

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFMOVENSINOIMPRESILICAO.CODCOLIGADA FKPFMOVENSIMPRES_PFMOVENSIMPR
PCCUSTO.CODCOLIGADA FKPFMOVENSINOIMP_PCCUSTOR
PFUNC.CODCOLIGADA FKPFMOVENSINOIMP_PFUNCR
PEVENTO.CODCOLIGADA FKPFMOVENSINOIMP_PEVENTOR
SATIVIDADEEXTRA.CODCOLIGADA FKPFMOVENSINOIMP_SATIVIDADEEXTR
STURMA.CODCOLIGADA FKPFMOVENSINOIMP_STURMAR
SDISCIPLINA.CODCOLIGADA FKPFMOVENSINOIMP_SDISCIPLINAR
CHAPA DCHAPA 16 null
PFMOVENSINOIMPRESILICAO.CHAPA FKPFMOVENSIMPRES_PFMOVENSIMPR
PFUNC.CHAPA FKPFMOVENSINOIMP_PFUNCR
CODEVENTO varchar 4 null
PFMOVENSINOIMPRESILICAO.CODEVENTO FKPFMOVENSIMPRES_PFMOVENSIMPR
PEVENTO.CODIGO FKPFMOVENSINOIMP_PEVENTOR
IDPROFTURMAATIV int 4 null
PFMOVENSINOIMPRESILICAO.IDPROFTURMAATIV FKPFMOVENSIMPRES_PFMOVENSIMPR
CARGAHORARIA RMDVALOR4 17,4 null
VALORHORA RMDVALOR2 17,2 null
ORIGEMATIVIDADE char 1 null
DATAINICIO datetime 16,3 null
PFHSTGRADEREMUN.DATAINICIO Implied ConstraintR
DATAFIM datetime 16,3 null
CODCCUSTO varchar 25 √ null
PCCUSTO.CODCCUSTO FKPFMOVENSINOIMP_PCCUSTOR
COMPOESALARIO DLOGICO 2 null
VALORFIXO RMDVALOR2 17,2 √ null
CODFILIAL smallint 2 √ null
STURMA.CODFILIAL FKPFMOVENSINOIMP_STURMAR
IDPERLET int 4 √ null
STURMA.IDPERLET FKPFMOVENSINOIMP_STURMAR
CODTURMA varchar 20 √ null
STURMA.CODTURMA FKPFMOVENSINOIMP_STURMAR
CODDISC varchar 20 √ null
SDISCIPLINA.CODDISC FKPFMOVENSINOIMP_SDISCIPLINAR
IDATIVIDADEEXTRA int 4 √ null
SATIVIDADEEXTRA.IDATIVIDADEEXTRA FKPFMOVENSINOIMP_SATIVIDADEEXTR
DATAINICIOPERLET datetime 16,3 √ null
DATAFIMPERLET datetime 16,3 √ null
EDITADO smallint 2 √ null
QTDALUNOS int 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
EQUIVHORAAULA int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPFMOVENSINOIMP Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + CODEVENTO + IDPROFTURMAATIV

Relationships

Close relationships within degrees of separation