PFMOVENSINOLOG

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
CHAPA DCHAPA 16 null
ANOCOMP smallint 2 null
MESCOMP smallint 2 null
CODEVENTO varchar 4 null
IDMOVENSINO int 4 null
IDPERLET int 4 √ null
CODDISC varchar 20 √ null
CODTURMA varchar 20 √ null
IDATIVIDADEEXTRA int 4 √ null
IDATIVIDADEOFERTADA int 4 √ null
TIPOATIVIDADE char 1 √ null
CARGAHORARIAATIVPROF RMDVALOR2 17,2 √ null
QTEAULASSEMANAIS int 4 √ null
VALORHORAATIV RMDVALOR2 17,2 √ null
VALORFIXO RMDVALOR2 17,2 √ null
VALORHORATITULACAO RMDVALOR2 17,2 √ null
CODCCUSTO varchar 25 √ null
EQUIVHORAAULA int 4 √ null
DTINICIO datetime 16,3 √ null
DTFIM datetime 16,3 √ null
COMPOESALARIO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
VALORMENSAL RMDVALOR2 17,2 √ null
JORNADAMENSAL smallint 2 √ null
VALORESFORCADOS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
IDPROFESSORTURMAATIV int 4 √ null
VALORMENSALPROP RMDVALOR2 17,2 √ null
JORNADAMENSALPROP smallint 2 √ null
QTDALUNOS int 4 √ null
CODUSUARIOLOG varchar 20 null
DATAHORALOG datetime 16,3 null
IDPROCESSOLOG smallint 2 null
TIPOALTERACAOLOG smallint 2 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDITEMCONTABIL int 4 √ null
IDCLASSEVALOR int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPFMOVENSINOLOG Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + ANOCOMP + MESCOMP + CODEVENTO + IDMOVENSINO + DATAHORALOG

Diagram producer might be missing

No diagrams were produced please see application output for any errors