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_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_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_tree_favorite.ad_user_id aduser_adtreefavorite R
ad_treebar.ad_user_id aduser_adtreebar C
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_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_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.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.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.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_activity.ad_user_id aduser_cofactivity R
cof_activity.cof_lead_id lead_cofactivity R
cof_activity.salesrep_id salesrep_cofactivity 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_chamadapbx.ad_user_id aduser_cofchamadapbx R
cof_configovs.ad_user_id aduser_cofconfigovs R
cof_contract.ad_user_id aduser_cofcontract R
cof_contract.salesrep_id salesrep_cofcontract R
cof_csc.createdby createdby_cofcsc R
cof_csc.updatedby updatedby_cofcsc R
cof_gruposeparacao.createdby createdby_cofgruposeparacao R
cof_gruposeparacao.updatedby updatedby_cofgruposeparacao R
cof_ocorrenciaembdes.cof_solucionadopor_id cofsolucionadopor_cofocorrenci R
cof_packinglist.cof_porteiroentrada_id cofporteiroentrada_cofpackingl R
cof_packinglist.cof_porteirosaida_id cofporteirosaida_cofpackinglis R
cof_produtosgruposeparacao.createdby createdby_cofprodutosgruposepa R
cof_produtosgruposeparacao.updatedby updatedby_cofprodutosgruposepa R
cof_restricaoacesso.cof_user_id cofuser_cofrestricaoacesso R
cof_retentionconfig.createdby createdby_cofretentionconfig R
cof_retentionconfig.updatedby updatedby_cofretentionconfig R
cof_titulo.createdby createdby_coftitulo R
cof_titulo.updatedby updatedby_coftitulo 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_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_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
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
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 16 √ NULL::character varying
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

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_islocked_check ((islocked = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_ismenuautoexpand_check ((ismenuautoexpand = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isnoexpire_check ((isnoexpire = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_issupportuser_check ((issupportuser = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isshipto_check ((isshipto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_cof_internaluser_check ((cof_internaluser = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isnopasswordreset_check ((isnopasswordreset = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isvendorlead_check ((isvendorlead = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isinpayroll_check ((isinpayroll = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isaddmailtextautomatically_check ((isaddmailtextautomatically = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_lbr_isnfecontact_check ((lbr_isnfecontact = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_cof_notifypurchase_check ((cof_notifypurchase = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isbillto_check ((isbillto = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_issaleslead_check ((issaleslead = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_cof_isxmlemail_check ((cof_isxmlemail = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_user_isexpired_check ((isexpired = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation