ad_user

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_user_id numeric 10 null
a_asset.ad_user_id aduser_aasset R
a_asset_change.ad_user_id aduser_aassetchange R
a_asset_change.c_invoice_ad_user_id cinvoiceaduser_aassetchange R
a_asset_delivery.ad_user_id aduser_aassetdelivery R
a_asset_group_trl.createdby createdby_aassetgrouptrl R
a_asset_group_trl.updatedby updatedby_aassetgrouptrl R
a_registration.ad_user_id aduser_aregistration R
ad_alertprocessor.supervisor_id aduser_calertprocessor R
ad_alertrecipient.ad_user_id aduser_adalertrecipient R
ad_attachmentnote.ad_user_id aduser_adattachmentnote R
ad_authorizationaccount.ad_user_id aduser_adauthorizationaccount R
ad_broadcastmessage.ad_user_id aduser_adbroadcastmessage R
ad_broadcastmessage_trl.createdby createdby_adbroadcastmessagetr R
ad_broadcastmessage_trl.updatedby updatedby_adbroadcastmessagetr R
ad_chart_trl.createdby createdby_adcharttrl R
ad_chart_trl.updatedby updatedby_adcharttrl R
ad_color_trl.createdby createdby_adcolortrl R
ad_color_trl.updatedby updatedby_adcolortrl R
ad_importtemplate.createdby createdby_adimporttemplate R
ad_importtemplate.updatedby updatedby_adimporttemplate R
ad_importtemplateaccess.createdby createdby_adimporttemplateacce R
ad_importtemplateaccess.updatedby updatedby_adimporttemplateacce R
ad_inforelated.createdby createdby_adinforelated R
ad_inforelated.updatedby updatedby_adinforelated R
ad_label_trl.createdby createdby_adlabeltrl R
ad_label_trl.updatedby updatedby_adlabeltrl R
ad_labelcategory_trl.createdby createdby_adlabelcategorytrl R
ad_labelcategory_trl.updatedby updatedby_adlabelcategorytrl R
ad_ldapaccess.ad_user_id aduser_adldapaccess R
ad_ldapprocessor.supervisor_id aduser_adldapprocessor R
ad_modelgeneratortemplate.createdby createdby_admodelgeneratortemp R
ad_modelgeneratortemplate.updatedby updatedby_admodelgeneratortemp R
ad_note.ad_user_id aduser_adnote R
ad_orginfo.supervisor_id aduser_adorginfo N
ad_password_history.ad_user_id aduser_adpasswordhistory R
ad_password_history.createdby createdby_adpasswordhistory R
ad_password_history.updatedby updatedby_adpasswordhistory R
ad_pinstance.ad_user_id aduser_pinstance R
ad_postit.createdby createdby_adpostit R
ad_postit.updatedby updatedby_adpostit R
ad_preference.ad_user_id ad_user_preference R
ad_printcolor_trl.createdby createdby_adprintcolortrl R
ad_printcolor_trl.updatedby updatedby_adprintcolortrl R
ad_private_access.ad_user_id aduser_adprivateaccess R
ad_recentitem.ad_user_id aduser_adrecentitem C
ad_reportview_column.createdby createdby_adreportviewcolumn R
ad_reportview_column.updatedby updatedby_adreportviewcolumn R
ad_requiredplugin.createdby createdby_adrequiredplugin R
ad_requiredplugin.updatedby updatedby_adrequiredplugin R
ad_role.supervisor_id adusersupervisor_adrole R
ad_scheduler.supervisor_id aduser_adscheduler R
ad_schedulerrecipient.ad_user_id aduser_adschedulerrecipient R
ad_statusline.createdby createdby_adstatusline R
ad_statusline.updatedby updatedby_adstatusline R
ad_statuslineusedin.createdby createdby_adstatuslineusedin R
ad_statuslineusedin.updatedby updatedby_adstatuslineusedin R
ad_tab_customization.ad_user_id aduser_adtabcustomization C
ad_tablevalrule.ad_user_id aduser_adtablevalrule R
ad_tablevalrule.createdby createdby_adtablevalrule R
ad_tablevalrule.updatedby updatedby_adtablevalrule R
ad_tree_favorite.ad_user_id aduser_adtreefavorite R
ad_treebar.ad_user_id aduser_adtreebar C
ad_user.cof_respatribuicao_id cofrespatribuicao_aduser R
ad_user.cof_responsavelindicacao_id cofresponsavelindicacao_aduser R
ad_user.salesrep_id salesrep_aduser R
ad_user.supervisor_id aduser_supervisor R
ad_user_orgaccess.ad_user_id aduser_aduserorgaccess R
ad_user_roles.ad_user_id aduser_userroles C
ad_user_substitute.ad_user_id aduser_adusersub C
ad_user_substitute.substitute_id adusersub_ad_usersub C
ad_userbpaccess.ad_user_id aduser_aduserbpaccess C
ad_userdef_info.ad_user_id aduser_aduserdefinfo R
ad_userdef_proc.ad_user_id aduser_aduserdefproc R
ad_userdef_theme.ad_user_id aduser_aduserdeftheme R
ad_userdef_theme.createdby createdby_aduserdeftheme R
ad_userdef_theme.updatedby updatedby_aduserdeftheme R
ad_userdef_theme_detail.createdby createdby_aduserdefthemedetail R
ad_userdef_theme_detail.updatedby updatedby_aduserdefthemedetail R
ad_userdef_win.ad_user_id aduser_aduserdefwin R
ad_usermail.ad_user_id aduser_adusermail C
ad_userpreference.ad_user_id aduser_aduserpreference C
ad_userpreference.createdby createdby_aduserpreference R
ad_userpreference.updatedby updatedby_aduserpreference R
ad_userquery.ad_user_id aduser_aduserquery C
ad_verifymigration.createdby createdby_adverifymigration R
ad_verifymigration.updatedby updatedby_adverifymigration R
ad_wf_activity.ad_user_id aduser_adwfactivity N
ad_wf_activityapprover.ad_user_id aduser_adwfactivityapprover R
ad_wf_eventaudit.ad_user_id aduser_adwfeventaudit R
ad_wf_process.ad_user_id aduser_adwfprocess R
ad_wf_responsible.ad_user_id aduser_adwfresponsible R
ad_wizardprocess.ad_user_id aduser_adwizardprocess R
ad_wlistbox_customization.ad_user_id aduser_adwlistboxcustomization R
ad_workflowprocessor.supervisor_id aduser_adworkflowprocessor R
b_bid.ad_user_id aduser_bbid R
b_bidcomment.ad_user_id aduser_bidcomment R
b_buyer.ad_user_id aduser_bbuyer R
b_buyerfunds.ad_user_id aduser_bbuyerfunds R
b_offer.ad_user_id aduser_boffer R
b_seller.ad_user_id aduser_bseller R
b_sellerfunds.ad_user_id aduser_bsellerfunds R
c_acctprocessor.supervisor_id aduser_cacctprocessor R
c_activity_trl.createdby createdby_cactivitytrl R
c_activity_trl.updatedby updatedby_cactivitytrl R
c_addresstransaction.createdby createdby_caddresstransaction R
c_addresstransaction.updatedby updatedby_caddresstransaction R
c_addressvalidation.createdby createdby_caddressvalidation R
c_addressvalidation.updatedby updatedby_caddressvalidation R
c_addressvalidationcfg.createdby createdby_caddressvalidationcf R
c_addressvalidationcfg.updatedby updatedby_caddressvalidationcf R
c_bp_bankaccount.ad_user_id aduser_cbpbankaccount R
c_bpartner.cof_vendedorinterno_id cofvendedorinterno_cbpartner R
c_bpartner.salesrep_id adusersalesrep_cbpartner N
c_campaign_trl.createdby createdby_ccampaigntrl R
c_campaign_trl.updatedby updatedby_ccampaigntrl R
c_contactactivity.ad_user_id aduser_ccontactactivity R
c_contactactivity.salesrep_id salesrep_ccontactactivity R
c_countrygroup.createdby createdby_ccountrygroup R
c_countrygroup.updatedby updatedby_ccountrygroup R
c_countrygroup_trl.createdby createdby_ccountrygrouptrl R
c_countrygroup_trl.updatedby updatedby_ccountrygrouptrl R
c_countrygroupcountry.createdby createdby_ccountrygroupcountry R
c_countrygroupcountry.updatedby updatedby_ccountrygroupcountry R
c_docbasegroup.createdby createdby_cperioddocgroup R
c_docbasegroup.updatedby updatedby_cperioddocgroup R
c_docbasegroupline.createdby createdby_cperioddocgroupline R
c_docbasegroupline.updatedby updatedby_cperioddocgroupline R
c_dunningrunentry.ad_user_id aduser_cdunningrunentry R
c_dunningrunentry.salesrep_id salesrep_cdunningrunentry R
c_invoice.ad_user_id aduser_cinvoice R
c_invoice.cof_digitador_id cofdigitador_cinvoice R
c_invoice.cof_vendedorinterno_id cofvendedorinterno_cinvoice R
c_invoice.salesrep_id aduser_sr_cinvoice R
c_invoicebatch.salesrep_id aduser_cinvoicebatch R
c_invoicebatchline.ad_user_id aduser_cinvoicebatchline R
c_jobassignment.ad_user_id aduser_cjobassignment R
c_opportunity.ad_user_id aduser_copportunity R
c_opportunity.cof_responsavelindicacao_id cofresponsavelindicacao_coppor R
c_opportunity.cof_vendedorinterno_id cofvendedorinterno_copportunit R
c_opportunity.salesrep_id salesrep_copportunity R
c_order.ad_user_id aduser_corder R
c_order.bill_user_id aduserbill_corder R
c_order.cof_digitador_id cofdigitador_corder R
c_order.cof_vendedorinterno_id cofvendedorinterno_corder R
c_order.dropship_user_id dropshipuser_corder R
c_order.salesrep_id aduser_sr_corder R
c_ordersource.createdby aduser1_cordersource R
c_ordersource.updatedby aduser2_cordersource R
c_orgassignment.ad_user_id aduser_corgassignment R
c_pos.salesrep_id aduser_cpos R
c_project.ad_user_id aduser_cproject N
c_project.salesrep_id aduser_sr_cproject R
c_recurringgroup.createdby createdby_crecurringgroup R
c_recurringgroup.updatedby updatedby_crecurringgroup R
c_region_trl.createdby createdby_cregiontrl R
c_region_trl.updatedby updatedby_cregiontrl R
c_revenuerecog_service.createdby createdby_crevenuerecogservice R
c_revenuerecog_service.updatedby updatedby_crevenuerecogservice R
c_rfq.ad_user_id aduser_crfq R
c_rfq.salesrep_id adusersalesrep_crfq R
c_rfq_topicsubscriber.ad_user_id aduser_arfqtopicsubcr R
c_rfqresponse.ad_user_id aduser_crfqresponse R
c_salesregion.salesrep_id salesrep_csalesregion R
c_salesregion_trl.createdby createdby_csalesregiontrl R
c_salesregion_trl.updatedby updatedby_csalesregiontrl R
c_salesstage_trl.createdby createdby_csalesstagetrl R
c_salesstage_trl.updatedby updatedby_csalesstagetrl R
c_taxprovider.createdby createdby_ctaxprovider R
c_taxprovider.updatedby updatedby_ctaxprovider R
c_taxprovidercfg.createdby createdby_adtaxprovider R
c_taxprovidercfg.updatedby updatedby_adtaxprovider R
c_userremuneration.ad_user_id aduser_cuserremuneration R
cm_chatentry.ad_user_id aduser_cmchatentry R
cm_chattypeupdate.ad_user_id aduser_cmchattypeupdate C
cm_chatupdate.ad_user_id aduser_cmchatupdate C
cm_webaccesslog.ad_user_id aduser_cmwebaccesslog R
cof_acaodossiefinanceiro.createdby createdby_cofacaodossiefinanceiro R
cof_acaodossiefinanceiro.updatedby updatedby_cofacaodossiefinanceiro R
cof_activity.ad_user_id aduser_cofactivity R
cof_activity.cof_lead_id lead_cofactivity R
cof_activity.salesrep_id salesrep_cofactivity R
cof_apuracaooutra.createdby createdby_cofapuracaooutra R
cof_apuracaooutra.updatedby updatedby_cofapuracaooutra R
cof_c_alinea.createdby createdby_cofcalinea R
cof_c_alinea.updatedby updatedby_cofcalinea R
cof_c_bankintegration.ad_user_id aduser_cofcbankintegration R
cof_c_bankintegration.createdby createdby_cofcbankintegration R
cof_c_bankintegration.updatedby updatedby_cofcbankintegration R
cof_c_bankoccurrence.createdby createdby_cofcbankoccurrence R
cof_c_bankoccurrence.updatedby updatedby_cofcbankoccurrence R
cof_c_checkallocate.createdby createdby_cofccheckallocate R
cof_c_checkallocate.updatedby updatedby_cofccheckallocate R
cof_c_cnabconfig.createdby createdby_cofccnabconfig R
cof_c_cnabconfig.updatedby updatedby_cofccnabconfig R
cof_c_cnabconfig_line.createdby createdby_cofccnabconfigline R
cof_c_cnabconfig_line.updatedby updatedby_cofccnabconfigline R
cof_c_controlcheck.createdby createdby_cofccontrolcheck R
cof_c_controlcheck.updatedby updatedby_cofccontrolcheck R
cof_c_custody.createdby createdby_cofccustody R
cof_c_custody.updatedby updatedby_cofccustody R
cof_c_titulo_audit.ad_user_id aduser_cofctituloaudit R
cof_calcnivelminmax.createdby createdby_cofcalcnivelminmax R
cof_calcnivelminmax.updatedby updatedby_cofcalcnivelminmax R
cof_calculociap.createdby createdby_cofcalculociap R
cof_calculociap.updatedby updatedby_cofcalculociap R
cof_calculociaplinha.createdby createdby_cofcalculociaplinha R
cof_calculociaplinha.updatedby updatedby_cofcalculociaplinha R
cof_calculociaplinhanfe.createdby createdby_cofcalculociaplinhanfe R
cof_calculociaplinhanfe.updatedby updatedby_cofcalculociaplinhanfe R
cof_calculociapoutroscred.createdby createdby_cofcalculociapoutroscred R
cof_calculociapoutroscred.updatedby updatedby_cofcalculociapoutroscred R
cof_chamadapbx.ad_user_id aduser_cofchamadapbx R
cof_cobranca_pix.createdby createdby_cofcobrancapix R
cof_cobranca_pix.updatedby updatedby_cofcobrancapix R
cof_codclasstrib.createdby createdby_cofcodclasstrib R
cof_codclasstrib.updatedby updatedby_cofcodclasstrib R
cof_codigooperacao.createdby createdby_cofcodigooperacao R
cof_codigooperacao.updatedby updatedby_cofcodigooperacao R
cof_combustivel.createdby createdby_cofcombustivel R
cof_combustivel.updatedby updatedby_cofcombustivel R
cof_configovs.ad_user_id aduser_cofconfigovs R
cof_configuracaociap.createdby createdby_cofconfiguracaociap R
cof_configuracaociap.updatedby updatedby_cofconfiguracaociap R
cof_configuracaofiscal.createdby createdby_cofconfiguracaofiscal R
cof_configuracaofiscal.updatedby updatedby_cofconfiguracaofiscal R
cof_configuracaometa.createdby createdby_cofconfiguracaometa R
cof_configuracaometa.updatedby updatedby_cofconfiguracaometa R
cof_confrontoofx.createdby createdby_cofconfrontoofx R
cof_confrontoofx.updatedby updatedby_cofconfrontoofx R
cof_contract.ad_user_id aduser_cofcontract R
cof_contract.salesrep_id salesrep_cofcontract R
cof_controleabastecimento.createdby createdby_cofcontroleabastecim R
cof_controleabastecimento.updatedby updatedby_cofcontroleabastecim R
cof_controleciap.createdby createdby_cofcontroleciap R
cof_controleciap.updatedby updatedby_cofcontroleciap R
cof_controleciap_entrada.createdby createdby_cofcontroleciapentrada R
cof_controleciap_entrada.updatedby updatedby_cofcontroleciapentrada R
cof_controleciap_saida.createdby createdby_cofcontroleciapsaida R
cof_controleciap_saida.updatedby updatedby_cofcontroleciapsaida R
cof_controleciapoutroscred.createdby createdby_cofcontroleciapoutroscred R
cof_controleciapoutroscred.updatedby updatedby_cofcontroleciapoutroscred R
cof_controlemulta.ad_user_id aduser_cofcontrolemulta R
cof_controlemulta.createdby createdby_cofcontrolemulta R
cof_controlemulta.updatedby updatedby_cofcontrolemulta R
cof_csc.createdby createdby_cofcsc R
cof_csc.updatedby updatedby_cofcsc R
cof_dda.createdby createdby_cofdda R
cof_dda.updatedby updatedby_cofdda R
cof_formacaopreco.createdby createdby_cofformacaopreco R
cof_formacaopreco.updatedby updatedby_cofformacaopreco R
cof_formacaoprecolista.createdby createdby_cofformacaoprecolist R
cof_formacaoprecolista.updatedby updatedby_cofformacaoprecolist R
cof_gruponcm.createdby createdby_cofgruponcm R
cof_gruponcm.updatedby updatedby_cofgruponcm R
cof_gruponcmlinha.createdby createdby_cofgruponcmlinha R
cof_gruponcmlinha.updatedby updatedby_cofgruponcmlinha R
cof_gruposeparacao.createdby createdby_cofgruposeparacao R
cof_gruposeparacao.updatedby updatedby_cofgruposeparacao R
cof_historicoconsultas.ad_user_id aduser_cofhistoricoconsultas R
cof_historicoconsultas.createdby createdby_cofhistoricoconsultas R
cof_historicoconsultas.updatedby updatedby_cofhistoricoconsultas R
cof_imagenslinhaov.createdby createdby_cofimagenslinhaov R
cof_imagenslinhaov.updatedby updatedby_cofimagenslinhaov R
cof_invoicededucaomateriais.createdby createdby_cofinvoicededucaomateriais R
cof_invoicededucaomateriais.updatedby updatedby_cofinvoicededucaomateriais R
cof_linhacalculo.createdby createdby_coflinhacalculo R
cof_linhacalculo.updatedby updatedby_coflinhacalculo R
cof_linharecuperacaoimposto.createdby createdby_coflinharecuperacaoimposto R
cof_linharecuperacaoimposto.updatedby updatedby_coflinharecuperacaoimposto R
cof_linhareposicao.createdby createdby_coflinhareposicao R
cof_linhareposicao.updatedby updatedby_coflinhareposicao R
cof_mdfe.createdby createdby_cofmdfe R
cof_mdfe.updatedby updatedby_cofmdfe R
cof_mdfe_condutor.createdby createdby_cofmdfecondutor R
cof_mdfe_condutor.updatedby updatedby_cofmdfecondutor R
cof_mdfe_documentofiscal.createdby createdby_cofmdfedocumentofisc R
cof_mdfe_documentofiscal.updatedby updatedby_cofmdfedocumentofisc R
cof_mdfe_muncarregamento.createdby createdby_cofmdfemuncarregamen R
cof_mdfe_muncarregamento.updatedby updatedby_cofmdfemuncarregamen R
cof_mdfe_mundescarregamento.createdby createdby_cofmdfemundescarrega R
cof_mdfe_mundescarregamento.updatedby updatedby_cofmdfemundescarrega R
cof_mdfe_percurso.createdby createdby_cofmdfepercurso R
cof_mdfe_percurso.updatedby updatedby_cofmdfepercurso R
cof_mdfe_reboque.createdby createdby_cofmdfereboque R
cof_mdfe_reboque.updatedby updatedby_cofmdfereboque R
cof_metadevendas.ad_user_id aduser_cofmetadevendas R
cof_metadevendas.createdby createdby_cofmetadevendas R
cof_metadevendas.updatedby updatedby_cofmetadevendas R
cof_ocorrenciaembdes.cof_solucionadopor_id cofsolucionadopor_cofocorrenci R
cof_orderdeducaomateriais.createdby createdby_coforderdeducaomateriais R
cof_orderdeducaomateriais.updatedby updatedby_coforderdeducaomateriais R
cof_packinglist.cof_porteiroentrada_id cofporteiroentrada_cofpackingl R
cof_packinglist.cof_porteirosaida_id cofporteirosaida_cofpackinglis R
cof_parametroavancadobusca.createdby createdby_cofparametroavancadobusca R
cof_parametroavancadobusca.updatedby updatedby_cofparametroavancadobusca R
cof_paramformacaopreco.createdby createdby_cofparamformacaoprec R
cof_paramformacaopreco.updatedby updatedby_cofparamformacaoprec R
cof_pontoremessa.createdby createdby_cofpontoremessa R
cof_pontoremessa.updatedby updatedby_cofpontoremessa R
cof_pontoremessa_trl.createdby createdby_cofpontoremessatrl R
cof_pontoremessa_trl.updatedby updatedby_cofpontoremessatrl R
cof_produtolocalizadorconfig.createdby createdby_cofprodutolocalizadorconfig R
cof_produtolocalizadorconfig.updatedby updatedby_cofprodutolocalizadorconfig R
cof_recuperacaoimposto.createdby createdby_cofrecuperacaoimposto R
cof_recuperacaoimposto.updatedby updatedby_cofrecuperacaoimposto R
cof_reposicaoestoquefilial.createdby createdby_cofreposicaoestoquefilial R
cof_reposicaoestoquefilial.updatedby updatedby_cofreposicaoestoquefilial R
cof_restricaoacesso.cof_user_id cofuser_cofrestricaoacesso R
cof_retentionconfig.createdby createdby_cofretentionconfig R
cof_retentionconfig.updatedby updatedby_cofretentionconfig R
cof_terminalcfe.createdby createdby_cofterminalcfe R
cof_terminalcfe.updatedby updatedby_cofterminalcfe R
cof_titulo.createdby createdby_coftitulo R
cof_titulo.updatedby updatedby_coftitulo R
cof_wpp_configwhatsapp.createdby createdby_zwppconfigwhatsapp R
cof_wpp_configwhatsapp.updatedby updatedby_zwppconfigwhatsapp R
cte_infctecomp.createdby createdby_cteinfctecomp R
cte_infctecomp.updatedby updatedby_cteinfctecomp R
dd_order.ad_user_id aduser_ddorder R
dd_order.salesrep_id salesrep_ddorder R
gl_category_trl.createdby createdby_glcategorytrl R
gl_category_trl.updatedby updatedby_glcategorytrl R
hr_job.supervisor_id supervisor_hrjob R
i_bpartner.ad_user_id aduser_ibpartner N
i_invoice.ad_user_id aduser_iinvoice N
i_invoice.salesrep_id adusersalesrep_iinvoice N
i_movement.ad_user_id aduser_imovement R
i_order.ad_user_id aduser_iorder N
i_order.salesrep_id adusersalesrep_iorder N
i_productplanning.planner_id planner_iproductplanning R
i_productplanning.salesrep_id salesrep_iproductplanning R
lbr_docfiscal_autxml.createdby createdby_lbrdocfiscalautxml R
lbr_docfiscal_autxml.updatedby updatedby_lbrdocfiscalautxml R
lbr_docfiscal_cana_deduc.createdby createdby_lbrdocfiscalcanadedu R
lbr_docfiscal_cana_deduc.updatedby updatedby_lbrdocfiscalcanadedu R
lbr_docfiscal_cana_fordia.createdby createdby_lbrdocfiscalcanaford R
lbr_docfiscal_cana_fordia.updatedby updatedby_lbrdocfiscalcanaford R
lbr_docfiscal_detpag.createdby createdby_lbrdocfiscalpag R
lbr_docfiscal_detpag.updatedby updatedby_lbrdocfiscalpag R
lbr_docfiscal_line_arma.createdby createdby_lbrdocfiscallinearma R
lbr_docfiscal_line_arma.updatedby updatedby_lbrdocfiscallinearma R
lbr_docfiscal_line_detexport.createdby createdby_lbrdocfiscallinedete R
lbr_docfiscal_line_detexport.updatedby updatedby_lbrdocfiscallinedete R
lbr_docfiscal_line_nve.createdby createdby_lbrdocfiscallinenve R
lbr_docfiscal_line_nve.updatedby updatedby_lbrdocfiscallinenve R
lbr_docfiscal_obscont.createdby createdby_lbrdocfiscalobscont R
lbr_docfiscal_obscont.updatedby updatedby_lbrdocfiscalobscont R
lbr_docfiscal_obsfisco.createdby createdby_lbrdocfiscalobsfisco R
lbr_docfiscal_obsfisco.updatedby updatedby_lbrdocfiscalobsfisco R
lbr_docfiscal_procref.createdby createdby_lbrdocfiscalprocref R
lbr_docfiscal_procref.updatedby updatedby_lbrdocfiscalprocref R
m_attributeinstanceline.createdby createdby_mattributeinstanceli R
m_attributeinstanceline.updatedby updatedby_mattributeinstanceli R
m_forecastline.salesrep_id salesrep_mforecastline R
m_inout.ad_user_id aduser_minout R
m_inout.dropship_user_id dropshipuser_minout R
m_inout.returnuser_id returnuser_minout R
m_inout.salesrep_id aduser_sr_minout R
m_inventory.ad_user_id aduser_minventory R
m_locatortype.createdby createdby_mlocatortype R
m_locatortype.updatedby updatedby_mlocatortype R
m_movement.ad_user_id aduser_mmovement R
m_movement.salesrep_id salesrep_mmovement R
m_pricelist_trl.createdby createdby_mpricelisttrl R
m_pricelist_trl.updatedby updatedby_mpricelisttrl R
m_pricelist_version_trl.createdby createdby_mpricelistversiontrl R
m_pricelist_version_trl.updatedby updatedby_mpricelistversiontrl R
m_product.salesrep_id salesrep_mproduct R
m_product_category_trl.createdby createdby_mproductcategorytrl R
m_product_category_trl.updatedby updatedby_mproductcategorytrl R
m_requisition.ad_user_id aduser_mrequisition R
m_rma.salesrep_id salesrep_mrma R
m_shippingtransaction.ad_user_id aduser_mshippingtransaction R
m_shippingtransaction.returnuser_id returnuser_mshippingtransactio R
m_shippingtransaction.salesrep_id salesrep_mshippingtransaction R
m_storagereservationlog.createdby createdby_mstoragereservationl R
m_storagereservationlog.updatedby updatedby_mstoragereservationl R
mfa_registereddevice.ad_user_id aduser_mfaregistereddevice R
mfa_registration.ad_user_id aduser_mfaregistration R
mp_assetmeter.createdby createdby_mpassetmeter R
mp_assetmeter.updatedby updatedby_mpassetmeter R
mp_assetmeter_log.createdby createdby_mpassetmeterlog R
mp_assetmeter_log.updatedby updatedby_mpassetmeterlog R
mp_jobstandar.createdby createdby_mpjobstandar R
mp_jobstandar.updatedby updatedby_mpjobstandar R
mp_jobstandar_resource.createdby createdby_mpjobstandarresource R
mp_jobstandar_resource.updatedby updatedby_mpjobstandarresource R
mp_jobstandar_task.createdby createdby_mpjobstandartask R
mp_jobstandar_task.updatedby updatedby_mpjobstandartask R
mp_maintain.createdby createdby_mpmaintain R
mp_maintain.updatedby updatedby_mpmaintain R
mp_maintain_resource.createdby createdby_mpmaintainresource R
mp_maintain_resource.updatedby updatedby_mpmaintainresource R
mp_maintain_task.createdby createdby_mpmaintaintask R
mp_maintain_task.updatedby updatedby_mpmaintaintask R
mp_meter.createdby createdby_mpmeter R
mp_meter.updatedby updatedby_mpmeter R
mp_ot.ad_user_id aduser_mpot R
mp_ot.createdby createdby_mpot R
mp_ot.updatedby updatedby_mpot R
mp_ot_request.ad_user_id aduser_mpotrequest R
mp_ot_request.createdby createdby_mpotrequest R
mp_ot_request.updatedby updatedby_mpotrequest R
mp_ot_resource.createdby createdby_mpotresource R
mp_ot_resource.updatedby updatedby_mpotresource R
mp_ot_task.createdby createdby_mpottask R
mp_ot_task.updatedby updatedby_mpottask R
mp_prognosis.createdby createdby_mpprognosis R
mp_prognosis.updatedby updatedby_mpprognosis R
pa_dashboardcontent.ad_user_id aduser_padashboardcontent R
pa_dashboardcontent_access.ad_user_id aduser_padashboardcontentacces R
pa_dashboardcontent_access.createdby createdby_padashboardcontentac R
pa_dashboardcontent_access.updatedby updatedby_padashboardcontentac R
pa_dashboardpreference.ad_user_id aduser_padashboardpreference R
pa_documentstatusaccess.ad_user_id aduser_padocumentstatusaccess R
pa_goal.ad_user_id aduser_pagoal R
pivot_configuration.createdby createdby_pivotconfiguration R
pivot_configuration.updatedby updatedby_pivotconfiguration R
pivot_field.createdby createdby_pivotfield R
pivot_field.updatedby updatedby_pivotfield R
pp_cost_collector.ad_user_id aduser_ppcostcollector R
pp_cost_collector.user1_id user1_ppcostcollector R
pp_cost_collector.user2_id user2_ppcostcollector R
pp_mrp.planner_id planner_ppmrp R
pp_order.planner_id planner_pporder R
pp_order_bomline.ad_user_id aduser_pporderbomline R
pp_product_planning.planner_id planner_ppproductplanning R
r_categoryupdates.ad_user_id aduser_rcategoryupdates R
r_contactinterest.ad_user_id aduser_rcontactinterest R
r_groupupdates.ad_user_id aduser_ruserupdates R
r_issueuser.ad_user_id aduser_rissueuser R
r_request.ad_user_id aduser_rrequest R
r_request.salesrep_id adusersr_rrequest R
r_requestaction.ad_user_id aduser_rrequestaction R
r_requestaction.salesrep_id adusersr_rrequestaction R
r_requestprocessor.supervisor_id aduser_rrequestprocessor R
r_requestprocessor_route.ad_user_id aduser_rrequestprocessorroute R
r_requesttype.ad_user_id aduser_rrequesttype R
r_requesttypeupdates.ad_user_id aduser_rrequesttypeupdates R
r_requestupdates.ad_user_id aduser_rrequestupdates R
s_resource.ad_user_id aduser_sresource R
t_itensnaovendidosaclientes.salesrep_id salesrep_titensnaovendidosacli R
testuu.createdby createdby_testuu R
testuu.updatedby updatedby_testuu R
testuu_trl.createdby createdby_testuutrl R
testuu_trl.updatedby updatedby_testuutrl R
testuudet.createdby createdby_testuudet R
testuudet.updatedby updatedby_testuudet R
u_posterminal.salesrep_id salesrep_uposterminal R
w_advertisement.ad_user_id aduser_wadvertisement R
w_basket.ad_user_id aduser_wbasket R
w_click.ad_user_id aduser_wclick R
w_counter.ad_user_id aduser_wcounter R
w_store.salesrep_id salesrep_wstore R
ad_client_id numeric 10 null
ad_client.ad_client_id ad_user_client R
ad_org_id numeric 10 null
ad_org.ad_org_id ad_user_org R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description text 2147483647 √ null
password varchar 1024 √ null
email varchar 60 √ null
supervisor_id numeric 10 √ null
ad_user.ad_user_id aduser_supervisor R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_aduser C
processing bpchar 1 √ null
emailuser varchar 60 √ null
emailuserpw varchar 255 √ null
c_bpartner_location_id numeric 10 √ null
c_bpartner_location.c_bpartner_location_id cbplocation_aduser R
c_greeting_id numeric 10 √ null
c_greeting.c_greeting_id cgreeting_aduser R
title varchar 40 √ null
comments varchar 2000 √ null
phone varchar 40 √ null
phone2 varchar 40 √ null
fax varchar 40 √ null
lastcontact timestamp 29,6 √ null
lastresult varchar 255 √ null
birthday timestamp 29,6 √ null
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_aduser R
emailverify varchar 40 √ null
emailverifydate timestamp 29,6 √ null
notificationtype bpchar 1 'X'::bpchar
isfullbpaccess bpchar 1 'Y'::bpchar
c_job_id numeric 10 √ null
c_job.c_job_id cjob_aduser R
ldapuser varchar 60 √ null
connectionprofile bpchar 1 √ null
value varchar 40 √ null
userpin varchar 20 √ null
isinpayroll bpchar 1 'N'::bpchar
ad_user_uu varchar 36 √ NULL::character varying
ismenuautoexpand bpchar 1 √ null
salt varchar 32 √ null
islocked bpchar 1 'N'::bpchar
dateaccountlocked timestamp 29,6 √ null
failedlogincount numeric 10 (0)::numeric
datepasswordchanged timestamp 29,6 √ null
datelastlogin timestamp 29,6 √ null
isnopasswordreset bpchar 1 'N'::bpchar
isexpired bpchar 1 'N'::bpchar
securityquestion varchar 1024 √ null
answer varchar 1024 √ NULL::character varying
issaleslead bpchar 1 'N'::bpchar
c_location_id numeric 10 √ NULL::numeric
c_location.c_location_id clocation_aduser R
leadsource varchar 10 √ NULL::character varying
leadstatus varchar 10 √ NULL::character varying
leadsourcedescription varchar 255 √ NULL::character varying
leadstatusdescription varchar 255 √ NULL::character varying
c_campaign_id numeric 10 √ NULL::numeric
c_campaign.c_campaign_id ccampaign_aduser R
salesrep_id numeric 10 √ NULL::numeric
ad_user.ad_user_id salesrep_aduser R
bpname varchar 60 √ NULL::character varying
bp_location_id numeric 10 √ NULL::numeric
c_location.c_location_id bplocation_aduser R
lbr_isnfecontact bpchar 1 'N'::bpchar
isaddmailtextautomatically bpchar 1 'N'::bpchar
r_defaultmailtext_id numeric 10 √ NULL::numeric
r_mailtext.r_mailtext_id rdefaultmailtext_aduser R
lbr_cpf varchar 14 √ NULL::character varying
cof_amtreleased numeric 0 '0'::numeric
cof_validityrelease timestamp 29,6 √ null
cof_observation varchar 255 √ NULL::character varying
cof_notifypurchase bpchar 1 'N'::bpchar
cof_contacttype varchar 2 √ null
cof_c_marketsegment_id numeric 10 √ null
cof_c_marketsegment.cof_c_marketsegment_id cofcmarketsegment_aduser R
cof_score numeric 10 √ '0'::numeric
cof_c_leadexpirationreason_id numeric 10 √ NULL::numeric
cof_c_leadexpirationreason.cof_c_leadexpirationreason_id cofcleadexpirationreason_aduse R
cof_internaluser bpchar 1 'N'::bpchar
ad_image_id numeric 10 √ NULL::numeric
ad_image.ad_image_id adimage_aduser R
cof_isxmlemail bpchar 1 'N'::bpchar
isnoexpire bpchar 1 'N'::bpchar
issupportuser bpchar 1 'N'::bpchar
cof_bptypebr varchar 2 √ null
cof_cnpj varchar 14 √ null
cof_tokenportal varchar 255 √ NULL::character varying
cof_expirydate timestamp 29,6 √ null
cof_url varchar 120 √ null
isbillto bpchar 1 'N'::bpchar
isshipto bpchar 1 'N'::bpchar
isvendorlead bpchar 1 'N'::bpchar
c_subscription_id numeric 10 √ NULL::numeric
c_subscription.c_subscription_id csubscription_aduser R
cof_responsavelindicacao_id numeric 10 √ NULL::numeric
ad_user.ad_user_id cofresponsavelindicacao_aduser R
authenticationtype varchar 10 √ NULL::character varying
cof_respatribuicao_id numeric 10 √ null
ad_user.ad_user_id cofrespatribuicao_aduser R
cof_dataatribuicao timestamp 29,6 √ null
cof_wpp_iscontatowhatsapp bpchar 1 'N'::bpchar
cte_contato bpchar 1 'N'::bpchar
passwordhashalgorithm varchar 40 √ NULL::character varying
saltalgorithm varchar 40 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_user_pkey Primary key Asc ad_user_id
ad_user_c_bpartner_id Performance Asc c_bpartner_id
ad_user_email Performance Asc email
ad_user_name Performance Asc/Asc name + ad_user_id
ad_user_uu_idx Must be unique Asc ad_user_uu

Check Constraints

Constraint Name Constraint
ad_user_isvendorlead_check ((isvendorlead = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_cof_internaluser_check ((cof_internaluser = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isbillto_check ((isbillto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_cof_notifypurchase_check ((cof_notifypurchase = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isaddmailtextautomatically_check ((isaddmailtextautomatically = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_cof_isxmlemail_check ((cof_isxmlemail = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_islocked_check ((islocked = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_issupportuser_check ((issupportuser = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_lbr_isnfecontact_check ((lbr_isnfecontact = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isnopasswordreset_check ((isnopasswordreset = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isexpired_check ((isexpired = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_issaleslead_check ((issaleslead = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isnoexpire_check ((isnoexpire = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_cof_wpp_iscontatowhatsapp_check ((cof_wpp_iscontatowhatsapp = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_cte_contato_check ((cte_contato = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_ismenuautoexpand_check ((ismenuautoexpand = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isshipto_check ((isshipto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isinpayroll_check ((isinpayroll = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation