MPAR

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TIPOPAR varchar 1 ('G')
MOEDACORRENTE varchar 10 √ null
IDIOMAPROJECT varchar 1 √ null
NOMEOBRA varchar 20 √ null
CAMPOLIVRE1PRJ varchar 20 √ null
CAMPOLIVRE2PRJ varchar 20 √ null
CAMPOLIVRE3PRJ varchar 20 √ null
CAMPOLIVRE4PRJ varchar 20 √ null
CAMPOLIVREVALOR1PRJ varchar 20 √ null
CAMPOLIVREVALOR2PRJ varchar 20 √ null
MASCARAPRJ varchar 24 √ null
CAMPOLIVRE1LOGPRJ varchar 20 √ null
INTEGRADOPROTHEUS int 4 (0)
LISTADOCMODELO int 4 √ null
DESCLISTA int 4 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
NOMEFASEPRJORC varchar 50 √ null
NOMEFASEPRJVND varchar 50 √ null
NOMEFASEPRJPLAN varchar 50 √ null
NOMEFASEPRJEXEC varchar 50 √ null
NATUREZAINSUMO varchar 50 √ null
PERMITEDATALIBPDOCNT smallint 2 √ ((0))
CAMINHOREDE varchar 255 √ null
ABRIRANEXOREVMULTIPLA smallint 2 √ ((0))
REALINHARTOTALCNT smallint 2 ((0))
UTILIZAVARIOSPRJCOLETOR smallint 2 √ null
UTILIZAVARIOSCOLETORUSUARIO smallint 2 √ null
ENVIAEMAILLOGERROSGERAL smallint 2 √ null
DESTINATARIOEMAIL varchar 200 √ null
TEXTOPADRAOEMAIL varchar 500 √ null
LOGINPINI varchar 14 √ null
SENHAPINI varchar 255 √ null
WEBSERVICEPINI varchar 150 √ null
VALIDAFILIALEQUIPAMENTO smallint 2 √ null
ATUALIZAEQUIPAMENTOPROJETO smallint 2 √ null
URLWSPARPROTHEUS varchar 255 √ null
USUARIOWSPARPROTHEUS varchar 25 √ null
SENHAWSPARPROTHEUS varchar 25 √ null
INTEGRADOSIGAMNT smallint 2 √ null
INTEGRADOPONTOTERCEIROS smallint 2 √ null
TIMESHEETINICIODESCONTO varchar 5 √ null
TIMESHEETFIMDESCONTO varchar 5 √ null
TIMESHEETPERMITERETROATIVO smallint 2 √ null
TIMESHEETDIASRETROATIVOS int 4 √ null
TIMESHEETQTDEHRMINDESCONTO int 4 √ null
FLUIGPDOLIBPROCESSID varchar 100 √ null
FLUIGPDOLIBSTATEID varchar 100 √ null
XMLCONFIGPROJECT varchar 2500 √ null
OBRIGAFECHARTELASCALCULO smallint 2 √ null
UNDWORKPROJECT MEMO 2147483647 √ null
FLUIGPRJPROCESSID varchar 100 √ null
FLUIGPRJSTATEIDAPROVADO varchar 100 √ null
FLUIGPRJSTATEIDREPROVADO varchar 100 √ null
FLUIGCNTPROCESSID varchar 100 √ null
FLUIGCNTSTATEIDAPROVADO varchar 100 √ null
FLUIGCNTSTATEIDREPROVADO varchar 100 √ null
FLUIGPEDEXTRAPROCESSID varchar 100 √ null
FLUIGPEDEXTRASTATEIDAPROVADO varchar 100 √ null
FLUIGPEDEXTRASTATEIDREPROVADO varchar 100 √ null
FLUIGPDOLIBSTATEIDREPROVADO varchar 100 √ null
URLWSPROTHEUSCALENDARTURNO varchar 250 √ null
USUARIOWSPROTHEUSCALENDARTURNO varchar 250 √ null
PASSWORDWSPROTHEUSCALENDARTURN varchar 250 √ null
PERMITEIMAGEMCOLETOR smallint 2 √ null
PERMITEFOTOCOLETOR smallint 2 √ null
VALIDARQTDTAREFAPEDIDO int 4 ((1))
PERMITEUSARINTEROP int 4 √ ((0))
CAMPOEXTRAFUNCTOPMOBILE varchar 250 √ ('PPESSOA.APELIDO')
TIPOINTEGRACAORECURSOS smallint 2 ((0))
NOMEUNIDADESERVICO varchar 100 √ null
NOMELOCALSERVICO varchar 100 √ null
CAMPOBASEPROJECT int 4 √ ((0))

Indexes

Constraint Name Type Sort Column(s)
PKMPAR Primary key Asc TIPOPAR

Diagram producer might be missing

No diagrams were produced please see application output for any errors