テーブル情報
システム名 http://www.as-link.com/  作成者 秦　松甫 
サブシステム名 ERPlus@iDempiere3.1_daily  作成日 2016/3/7 
スキーマ名 adempiere  更新日  
論理テーブル名   RDBMS  PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit 9.4.5 
物理テーブル名 ad_user     
備考


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_user_id numeric(10) Yes (PK)
2 ad_client_id numeric(10) Yes
3 ad_org_id numeric(10) Yes
4 isactive character(1) Yes 'Y'
5 created timestamp without time zone Yes now()
6 createdby numeric(10) Yes
7 updated timestamp without time zone Yes now()
8 updatedby numeric(10) Yes
9 name character varying(60) Yes
10 description character varying(255)  
11 password character varying(1024)  
12 email character varying(60)  
13 supervisor_id numeric(10)  
14 c_bpartner_id numeric(10)  
15 processing character(1)  
16 emailuser character varying(60)  
17 emailuserpw character varying(255)  
18 c_bpartner_location_id numeric(10)  
19 c_greeting_id numeric(10)  
20 title character varying(40)  
21 comments character varying(2000)  
22 phone character varying(40)  
23 phone2 character varying(40)  
24 fax character varying(40)  
25 lastcontact timestamp without time zone  
26 lastresult character varying(255)  
27 birthday timestamp without time zone  
28 ad_orgtrx_id numeric(10)  
29 emailverify character varying(40)  
30 emailverifydate timestamp without time zone  
31 notificationtype character(1) Yes 'E'
32 isfullbpaccess character(1) Yes 'Y'
33 c_job_id numeric(10)  
34 ldapuser character varying(60)  
35 connectionprofile character(1)  
36 value character varying(40)  
37 userpin character varying(20)  
38 isinpayroll character(1) Yes 'N'
39 ad_user_uu character varying(36)   NULL
40 ismenuautoexpand character(1)  
41 salt character varying(16)   NULL
42 islocked character(1) Yes 'N'
43 dateaccountlocked timestamp without time zone  
44 failedlogincount numeric(10) Yes (0)
45 datepasswordchanged timestamp without time zone  
46 datelastlogin timestamp without time zone  
47 isnopasswordreset character(1) Yes 'N'
48 isexpired character(1) Yes 'N'
49 securityquestion character varying(1024)  
50 answer character varying(1024)   NULL
51 issaleslead character(1) Yes 'N'
52 c_location_id numeric(10)   NULL
53 leadsource character varying(10)   NULL
54 leadstatus character varying(10)   NULL
55 leadsourcedescription character varying(255)   NULL
56 leadstatusdescription character varying(255)   NULL
57 c_campaign_id numeric(10)   NULL
58 salesrep_id numeric(10)   NULL
59 bpname character varying(60)   NULL
60 bp_location_id numeric(10)   NULL
61 isaddmailtextautomatically character(1) Yes 'N'
62 r_defaultmailtext_id numeric(10)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 ad_user_email email    
2 ad_user_pkey ad_user_id Yes  
3 ad_user_uu_idx ad_user_uu Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 ad_user_client ad_client_id adempiere.ad_client ad_client_id
2 ad_user_org ad_org_id adempiere.ad_org ad_org_id
3 adorgtrx_aduser ad_orgtrx_id adempiere.ad_org ad_org_id
4 aduser_supervisor supervisor_id adempiere.ad_user ad_user_id
5 bplocation_aduser bp_location_id adempiere.c_location c_location_id
6 cbpartner_aduser c_bpartner_id adempiere.c_bpartner c_bpartner_id
7 cbplocation_aduser c_bpartner_location_id adempiere.c_bpartner_location c_bpartner_location_id
8 ccampaign_aduser c_campaign_id adempiere.c_campaign c_campaign_id
9 cgreeting_aduser c_greeting_id adempiere.c_greeting c_greeting_id
10 cjob_aduser c_job_id adempiere.c_job c_job_id
11 clocation_aduser c_location_id adempiere.c_location c_location_id
12 rdefaultmailtext_aduser r_defaultmailtext_id adempiere.r_mailtext r_mailtext_id
13 salesrep_aduser salesrep_id adempiere.ad_user ad_user_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 ad_user_preference ad_user_id adempiere.ad_preference ad_user_id
2 aduser1_cordersource ad_user_id adempiere.c_ordersource createdby
3 aduser2_cordersource ad_user_id adempiere.c_ordersource updatedby
4 aduser_aasset ad_user_id adempiere.a_asset ad_user_id
5 aduser_aassetchange ad_user_id adempiere.a_asset_change ad_user_id
6 aduser_aassetdelivery ad_user_id adempiere.a_asset_delivery ad_user_id
7 aduser_adalertrecipient ad_user_id adempiere.ad_alertrecipient ad_user_id
8 aduser_adattachmentnote ad_user_id adempiere.ad_attachmentnote ad_user_id
9 aduser_adbroadcastmessage ad_user_id adempiere.ad_broadcastmessage ad_user_id
10 aduser_adldapaccess ad_user_id adempiere.ad_ldapaccess ad_user_id
11 aduser_adldapprocessor ad_user_id adempiere.ad_ldapprocessor supervisor_id
12 aduser_adnote ad_user_id adempiere.ad_note ad_user_id
13 aduser_adorginfo ad_user_id adempiere.ad_orginfo supervisor_id
14 aduser_adprivateaccess ad_user_id adempiere.ad_private_access ad_user_id
15 aduser_adrecentitem ad_user_id adempiere.ad_recentitem ad_user_id
16 aduser_adscheduler ad_user_id adempiere.ad_scheduler supervisor_id
17 aduser_adschedulerrecipient ad_user_id adempiere.ad_schedulerrecipient ad_user_id
18 aduser_adtabcustomization ad_user_id adempiere.ad_tab_customization ad_user_id
19 aduser_adtreebar ad_user_id adempiere.ad_treebar ad_user_id
20 aduser_aduserbpaccess ad_user_id adempiere.ad_userbpaccess ad_user_id
21 aduser_aduserdefwin ad_user_id adempiere.ad_userdef_win ad_user_id
22 aduser_adusermail ad_user_id adempiere.ad_usermail ad_user_id
23 aduser_aduserorgaccess ad_user_id adempiere.ad_user_orgaccess ad_user_id
24 aduser_aduserpreference ad_user_id adempiere.ad_userpreference ad_user_id
25 aduser_aduserquery ad_user_id adempiere.ad_userquery ad_user_id
26 aduser_adusersub ad_user_id adempiere.ad_user_substitute ad_user_id
27 aduser_adwfactivity ad_user_id adempiere.ad_wf_activity ad_user_id
28 aduser_adwfeventaudit ad_user_id adempiere.ad_wf_eventaudit ad_user_id
29 aduser_adwfprocess ad_user_id adempiere.ad_wf_process ad_user_id
30 aduser_adwfresponsible ad_user_id adempiere.ad_wf_responsible ad_user_id
31 aduser_adwizardprocess ad_user_id adempiere.ad_wizardprocess ad_user_id
32 aduser_adworkflowprocessor ad_user_id adempiere.ad_workflowprocessor supervisor_id
33 aduser_aregistration ad_user_id adempiere.a_registration ad_user_id
34 aduser_arfqtopicsubcr ad_user_id adempiere.c_rfq_topicsubscriber ad_user_id
35 aduser_bbid ad_user_id adempiere.b_bid ad_user_id
36 aduser_bbuyer ad_user_id adempiere.b_buyer ad_user_id
37 aduser_bbuyerfunds ad_user_id adempiere.b_buyerfunds ad_user_id
38 aduser_bidcomment ad_user_id adempiere.b_bidcomment ad_user_id
39 aduser_boffer ad_user_id adempiere.b_offer ad_user_id
40 aduser_bseller ad_user_id adempiere.b_seller ad_user_id
41 aduser_bsellerfunds ad_user_id adempiere.b_sellerfunds ad_user_id
42 aduser_cacctprocessor ad_user_id adempiere.c_acctprocessor supervisor_id
43 aduser_calertprocessor ad_user_id adempiere.ad_alertprocessor supervisor_id
44 aduser_cbpbankaccount ad_user_id adempiere.c_bp_bankaccount ad_user_id
45 aduser_ccontactactivity ad_user_id adempiere.c_contactactivity ad_user_id
46 aduser_cdunningrunentry ad_user_id adempiere.c_dunningrunentry ad_user_id
47 aduser_cinvoice ad_user_id adempiere.c_invoice ad_user_id
48 aduser_cinvoicebatch ad_user_id adempiere.c_invoicebatch salesrep_id
49 aduser_cinvoicebatchline ad_user_id adempiere.c_invoicebatchline ad_user_id
50 aduser_cjobassignment ad_user_id adempiere.c_jobassignment ad_user_id
51 aduser_cmchatentry ad_user_id adempiere.cm_chatentry ad_user_id
52 aduser_cmchattypeupdate ad_user_id adempiere.cm_chattypeupdate ad_user_id
53 aduser_cmchatupdate ad_user_id adempiere.cm_chatupdate ad_user_id
54 aduser_cmwebaccesslog ad_user_id adempiere.cm_webaccesslog ad_user_id
55 aduser_copportunity ad_user_id adempiere.c_opportunity ad_user_id
56 aduser_corder ad_user_id adempiere.c_order ad_user_id
57 aduser_corgassignment ad_user_id adempiere.c_orgassignment ad_user_id
58 aduser_cpos ad_user_id adempiere.c_pos salesrep_id
59 aduser_cproject ad_user_id adempiere.c_project ad_user_id
60 aduser_crfq ad_user_id adempiere.c_rfq ad_user_id
61 aduser_crfqresponse ad_user_id adempiere.c_rfqresponse ad_user_id
62 aduser_cuserremuneration ad_user_id adempiere.c_userremuneration ad_user_id
63 aduser_ddorder ad_user_id adempiere.dd_order ad_user_id
64 aduser_ibpartner ad_user_id adempiere.i_bpartner ad_user_id
65 aduser_iinvoice ad_user_id adempiere.i_invoice ad_user_id
66 aduser_imovement ad_user_id adempiere.i_movement ad_user_id
67 aduser_iorder ad_user_id adempiere.i_order ad_user_id
68 aduser_minout ad_user_id adempiere.m_inout ad_user_id
69 aduser_mmovement ad_user_id adempiere.m_movement ad_user_id
70 aduser_mrequisition ad_user_id adempiere.m_requisition ad_user_id
71 aduser_mshippingtransaction ad_user_id adempiere.m_shippingtransaction ad_user_id
72 aduser_padashboardcontent ad_user_id adempiere.pa_dashboardcontent ad_user_id
73 aduser_padashboardcontentacces ad_user_id adempiere.pa_dashboardcontent_access ad_user_id
74 aduser_padashboardpreference ad_user_id adempiere.pa_dashboardpreference ad_user_id
75 aduser_pagoal ad_user_id adempiere.pa_goal ad_user_id
76 aduser_pinstance ad_user_id adempiere.ad_pinstance ad_user_id
77 aduser_ppcostcollector ad_user_id adempiere.pp_cost_collector ad_user_id
78 aduser_pporderbomline ad_user_id adempiere.pp_order_bomline ad_user_id
79 aduser_rcategoryupdates ad_user_id adempiere.r_categoryupdates ad_user_id
80 aduser_rcontactinterest ad_user_id adempiere.r_contactinterest ad_user_id
81 aduser_rissueuser ad_user_id adempiere.r_issueuser ad_user_id
82 aduser_rrequest ad_user_id adempiere.r_request ad_user_id
83 aduser_rrequestaction ad_user_id adempiere.r_requestaction ad_user_id
84 aduser_rrequestprocessor ad_user_id adempiere.r_requestprocessor supervisor_id
85 aduser_rrequestprocessorroute ad_user_id adempiere.r_requestprocessor_route ad_user_id
86 aduser_rrequesttypeupdates ad_user_id adempiere.r_requesttypeupdates ad_user_id
87 aduser_rrequestupdates ad_user_id adempiere.r_requestupdates ad_user_id
88 aduser_ruserupdates ad_user_id adempiere.r_groupupdates ad_user_id
89 aduser_sr_cinvoice ad_user_id adempiere.c_invoice salesrep_id
90 aduser_sr_corder ad_user_id adempiere.c_order salesrep_id
91 aduser_sr_cproject ad_user_id adempiere.c_project salesrep_id
92 aduser_sr_minout ad_user_id adempiere.m_inout salesrep_id
93 aduser_sresource ad_user_id adempiere.s_resource ad_user_id
94 aduser_supervisor ad_user_id adempiere.ad_user supervisor_id
95 aduser_userroles ad_user_id adempiere.ad_user_roles ad_user_id
96 aduser_wadvertisement ad_user_id adempiere.w_advertisement ad_user_id
97 aduser_wbasket ad_user_id adempiere.w_basket ad_user_id
98 aduser_wclick ad_user_id adempiere.w_click ad_user_id
99 aduser_wcounter ad_user_id adempiere.w_counter ad_user_id
100 aduserbill_corder ad_user_id adempiere.c_order bill_user_id
101 adusersalesrep_cbpartner ad_user_id adempiere.c_bpartner salesrep_id
102 adusersalesrep_crfq ad_user_id adempiere.c_rfq salesrep_id
103 adusersalesrep_iinvoice ad_user_id adempiere.i_invoice salesrep_id
104 adusersalesrep_iorder ad_user_id adempiere.i_order salesrep_id
105 adusersr_rrequest ad_user_id adempiere.r_request salesrep_id
106 adusersr_rrequestaction ad_user_id adempiere.r_requestaction salesrep_id
107 adusersub_ad_usersub ad_user_id adempiere.ad_user_substitute substitute_id
108 adusersupervisor_adrole ad_user_id adempiere.ad_role supervisor_id
109 createdby_aassetgrouptrl ad_user_id adempiere.a_asset_group_trl createdby
110 createdby_adbroadcastmessagetr ad_user_id adempiere.ad_broadcastmessage_trl createdby
111 createdby_adcharttrl ad_user_id adempiere.ad_chart_trl createdby
112 createdby_adcolortrl ad_user_id adempiere.ad_color_trl createdby
113 createdby_adimporttemplate ad_user_id adempiere.ad_importtemplate createdby
114 createdby_adimporttemplateacce ad_user_id adempiere.ad_importtemplateaccess createdby
115 createdby_adinforelated ad_user_id adempiere.ad_inforelated createdby
116 createdby_adpasswordhistory ad_user_id adempiere.ad_password_history createdby
117 createdby_adprintcolortrl ad_user_id adempiere.ad_printcolor_trl createdby
118 createdby_adreportviewcolumn ad_user_id adempiere.ad_reportview_column createdby
119 createdby_adstatusline ad_user_id adempiere.ad_statusline createdby
120 createdby_adstatuslineusedin ad_user_id adempiere.ad_statuslineusedin createdby
121 createdby_adtaxprovider ad_user_id adempiere.c_taxprovidercfg createdby
122 createdby_aduserpreference ad_user_id adempiere.ad_userpreference createdby
123 createdby_cactivitytrl ad_user_id adempiere.c_activity_trl createdby
124 createdby_caddresstransaction ad_user_id adempiere.c_addresstransaction createdby
125 createdby_caddressvalidation ad_user_id adempiere.c_addressvalidation createdby
126 createdby_caddressvalidationcf ad_user_id adempiere.c_addressvalidationcfg createdby
127 createdby_ccampaigntrl ad_user_id adempiere.c_campaign_trl createdby
128 createdby_ccountrygroup ad_user_id adempiere.c_countrygroup createdby
129 createdby_ccountrygroupcountry ad_user_id adempiere.c_countrygroupcountry createdby
130 createdby_ccountrygrouptrl ad_user_id adempiere.c_countrygroup_trl createdby
131 createdby_crecurringgroup ad_user_id adempiere.c_recurringgroup createdby
132 createdby_cregiontrl ad_user_id adempiere.c_region_trl createdby
133 createdby_csalesregiontrl ad_user_id adempiere.c_salesregion_trl createdby
134 createdby_csalesstagetrl ad_user_id adempiere.c_salesstage_trl createdby
135 createdby_ctaxprovider ad_user_id adempiere.c_taxprovider createdby
136 createdby_glcategorytrl ad_user_id adempiere.gl_category_trl createdby
137 createdby_mlocatortype ad_user_id adempiere.m_locatortype createdby
138 createdby_mpricelisttrl ad_user_id adempiere.m_pricelist_trl createdby
139 createdby_mpricelistversiontrl ad_user_id adempiere.m_pricelist_version_trl createdby
140 createdby_mproductcategorytrl ad_user_id adempiere.m_product_category_trl createdby
141 createdby_padashboardcontentac ad_user_id adempiere.pa_dashboardcontent_access createdby
142 dropshipuser_corder ad_user_id adempiere.c_order dropship_user_id
143 dropshipuser_minout ad_user_id adempiere.m_inout dropship_user_id
144 planner_iproductplanning ad_user_id adempiere.i_productplanning planner_id
145 planner_ppmrp ad_user_id adempiere.pp_mrp planner_id
146 planner_pporder ad_user_id adempiere.pp_order planner_id
147 planner_ppproductplanning ad_user_id adempiere.pp_product_planning planner_id
148 returnuser_minout ad_user_id adempiere.m_inout returnuser_id
149 returnuser_mshippingtransactio ad_user_id adempiere.m_shippingtransaction returnuser_id
150 salesrep_aduser ad_user_id adempiere.ad_user salesrep_id
151 salesrep_ccontactactivity ad_user_id adempiere.c_contactactivity salesrep_id
152 salesrep_cdunningrunentry ad_user_id adempiere.c_dunningrunentry salesrep_id
153 salesrep_copportunity ad_user_id adempiere.c_opportunity salesrep_id
154 salesrep_csalesregion ad_user_id adempiere.c_salesregion salesrep_id
155 salesrep_ddorder ad_user_id adempiere.dd_order salesrep_id
156 salesrep_iproductplanning ad_user_id adempiere.i_productplanning salesrep_id
157 salesrep_mforecastline ad_user_id adempiere.m_forecastline salesrep_id
158 salesrep_mmovement ad_user_id adempiere.m_movement salesrep_id
159 salesrep_mproduct ad_user_id adempiere.m_product salesrep_id
160 salesrep_mrma ad_user_id adempiere.m_rma salesrep_id
161 salesrep_mshippingtransaction ad_user_id adempiere.m_shippingtransaction salesrep_id
162 salesrep_uposterminal ad_user_id adempiere.u_posterminal salesrep_id
163 salesrep_wstore ad_user_id adempiere.w_store salesrep_id
164 supervisor_hrjob ad_user_id adempiere.hr_job supervisor_id
165 updatedby_aassetgrouptrl ad_user_id adempiere.a_asset_group_trl updatedby
166 updatedby_adbroadcastmessagetr ad_user_id adempiere.ad_broadcastmessage_trl updatedby
167 updatedby_adcharttrl ad_user_id adempiere.ad_chart_trl updatedby
168 updatedby_adcolortrl ad_user_id adempiere.ad_color_trl updatedby
169 updatedby_adimporttemplate ad_user_id adempiere.ad_importtemplate updatedby
170 updatedby_adimporttemplateacce ad_user_id adempiere.ad_importtemplateaccess updatedby
171 updatedby_adinforelated ad_user_id adempiere.ad_inforelated updatedby
172 updatedby_adpasswordhistory ad_user_id adempiere.ad_password_history updatedby
173 updatedby_adprintcolortrl ad_user_id adempiere.ad_printcolor_trl updatedby
174 updatedby_adreportviewcolumn ad_user_id adempiere.ad_reportview_column updatedby
175 updatedby_adstatusline ad_user_id adempiere.ad_statusline updatedby
176 updatedby_adstatuslineusedin ad_user_id adempiere.ad_statuslineusedin updatedby
177 updatedby_adtaxprovider ad_user_id adempiere.c_taxprovidercfg updatedby
178 updatedby_aduserpreference ad_user_id adempiere.ad_userpreference updatedby
179 updatedby_cactivitytrl ad_user_id adempiere.c_activity_trl updatedby
180 updatedby_caddresstransaction ad_user_id adempiere.c_addresstransaction updatedby
181 updatedby_caddressvalidation ad_user_id adempiere.c_addressvalidation updatedby
182 updatedby_caddressvalidationcf ad_user_id adempiere.c_addressvalidationcfg updatedby
183 updatedby_ccampaigntrl ad_user_id adempiere.c_campaign_trl updatedby
184 updatedby_ccountrygroup ad_user_id adempiere.c_countrygroup updatedby
185 updatedby_ccountrygroupcountry ad_user_id adempiere.c_countrygroupcountry updatedby
186 updatedby_ccountrygrouptrl ad_user_id adempiere.c_countrygroup_trl updatedby
187 updatedby_crecurringgroup ad_user_id adempiere.c_recurringgroup updatedby
188 updatedby_cregiontrl ad_user_id adempiere.c_region_trl updatedby
189 updatedby_csalesregiontrl ad_user_id adempiere.c_salesregion_trl updatedby
190 updatedby_csalesstagetrl ad_user_id adempiere.c_salesstage_trl updatedby
191 updatedby_ctaxprovider ad_user_id adempiere.c_taxprovider updatedby
192 updatedby_glcategorytrl ad_user_id adempiere.gl_category_trl updatedby
193 updatedby_mlocatortype ad_user_id adempiere.m_locatortype updatedby
194 updatedby_mpricelisttrl ad_user_id adempiere.m_pricelist_trl updatedby
195 updatedby_mpricelistversiontrl ad_user_id adempiere.m_pricelist_version_trl updatedby
196 updatedby_mproductcategorytrl ad_user_id adempiere.m_product_category_trl updatedby
197 updatedby_padashboardcontentac ad_user_id adempiere.pa_dashboardcontent_access updatedby
198 user1_ppcostcollector ad_user_id adempiere.pp_cost_collector user1_id
199 user2_ppcostcollector ad_user_id adempiere.pp_cost_collector user2_id


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 tablename ad_user
3 tableowner adempiere
4 tablespace
5 hasindexes True
6 hasrules False
7 hastriggers True