テーブル情報
システム名 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_client     
備考


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_client_id numeric(10) Yes (PK)
2 ad_org_id numeric(10) Yes
3 isactive character(1) Yes 'Y'
4 created timestamp without time zone Yes now()
5 createdby numeric(10) Yes
6 updated timestamp without time zone Yes now()
7 updatedby numeric(10) Yes
8 value character varying(40) Yes
9 name character varying(60) Yes
10 description character varying(255)  
11 smtphost character varying(60)  
12 requestemail character varying(60)  
13 requestuser character varying(60)  
14 requestuserpw character varying(255)  
15 requestfolder character varying(20)  
16 ad_language character varying(6)  
17 ismultilingualdocument character(1) Yes 'N'
18 issmtpauthorization character(1) Yes 'N'
19 isusebetafunctions character(1) Yes 'N'
20 ldapquery character varying(255)  
21 modelvalidationclasses character varying(255)  
22 autoarchive character(1) Yes 'N'
23 mmpolicy character(1) Yes 'F'
24 emailtest character(1)  
25 isserveremail character(1) Yes 'N'
26 documentdir character varying(60)  
27 ispostimmediate character(1) Yes 'N'
28 iscostimmediate character(1) Yes 'N'
29 storeattachmentsonfilesystem character(1) Yes 'N'
30 windowsattachmentpath character varying(255)  
31 unixattachmentpath character varying(255)  
32 storearchiveonfilesystem character(1) Yes 'N'
33 windowsarchivepath character varying(255)  
34 unixarchivepath character varying(255)  
35 isuseasp character(1) Yes 'N'
36 ad_replicationstrategy_id numeric(10)  
37 ad_client_uu character varying(36)   NULL
38 ad_passwordrule_id numeric(10)   NULL
39 issecuresmtp character(1) Yes 'N'
40 smtpport numeric(10)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 ad_client_pkey ad_client_id Yes  
2 ad_client_uu_idx ad_client_uu Yes  
3 ad_client_value value Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 adlangu_adclient ad_language adempiere.ad_language ad_language
2 adpasswordrule_adclient ad_passwordrule_id adempiere.ad_passwordrule ad_passwordrule_id
3 adreplicationstrategy_adclient ad_replicationstrategy_id adempiere.ad_replicationstrategy ad_replicationstrategy_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 ac_client_fact_acct ad_client_id adempiere.fact_acct ad_client_id
2 ad_client_c_acctschema ad_client_id adempiere.c_acctschema ad_client_id
3 ad_dataaccessclient ad_client_id adempiere.ad_table_access ad_client_id
4 ad_functaccess_client ad_client_id adempiere.ad_window_access ad_client_id
5 ad_preference_client ad_client_id adempiere.ad_preference ad_client_id
6 ad_processaccess_client ad_client_id adempiere.ad_process_access ad_client_id
7 ad_reflist_client ad_client_id adempiere.ad_ref_list ad_client_id
8 ad_roleclient ad_client_id adempiere.ad_role ad_client_id
9 ad_taskaccess_client ad_client_id adempiere.ad_task_access ad_client_id
10 ad_user_client ad_client_id adempiere.ad_user ad_client_id
11 ad_userrolesclient ad_client_id adempiere.ad_user_roles ad_client_id
12 ad_workflowaccess_client ad_client_id adempiere.ad_workflow_access ad_client_id
13 adclient_aassetgrouptrl ad_client_id adempiere.a_asset_group_trl ad_client_id
14 adclient_adbroadcastmessagetrl ad_client_id adempiere.ad_broadcastmessage_trl ad_client_id
15 adclient_adcharttrl ad_client_id adempiere.ad_chart_trl ad_client_id
16 adclient_adclientinfo ad_client_id adempiere.ad_clientinfo ad_client_id
17 adclient_adclientshare ad_client_id adempiere.ad_clientshare ad_client_id
18 adclient_adcolortrl ad_client_id adempiere.ad_color_trl ad_client_id
19 adclient_adimporttemplate ad_client_id adempiere.ad_importtemplate ad_client_id
20 adclient_adimporttemplateacces ad_client_id adempiere.ad_importtemplateaccess ad_client_id
21 adclient_adinforelated ad_client_id adempiere.ad_inforelated ad_client_id
22 adclient_admenu ad_client_id adempiere.ad_menu ad_client_id
23 adclient_adorg ad_client_id adempiere.ad_org ad_client_id
24 adclient_adprintcolortrl ad_client_id adempiere.ad_printcolor_trl ad_client_id
25 adclient_adprintform ad_client_id adempiere.ad_printform ad_client_id
26 adclient_adreportviewcolumn ad_client_id adempiere.ad_reportview_column ad_client_id
27 adclient_adstatusline ad_client_id adempiere.ad_statusline ad_client_id
28 adclient_adstatuslineusedin ad_client_id adempiere.ad_statuslineusedin ad_client_id
29 adclient_adtaxprovider ad_client_id adempiere.c_taxprovidercfg ad_client_id
30 adclient_aduserpreference ad_client_id adempiere.ad_userpreference ad_client_id
31 adclient_cactivitytrl ad_client_id adempiere.c_activity_trl ad_client_id
32 adclient_caddresstransaction ad_client_id adempiere.c_addresstransaction ad_client_id
33 adclient_caddressvalidation ad_client_id adempiere.c_addressvalidation ad_client_id
34 adclient_caddressvalidationcfg ad_client_id adempiere.c_addressvalidationcfg ad_client_id
35 adclient_caschemaelement ad_client_id adempiere.c_acctschema_element ad_client_id
36 adclient_cbpartner ad_client_id adempiere.c_bpartner ad_client_id
37 adclient_ccampaigntrl ad_client_id adempiere.c_campaign_trl ad_client_id
38 adclient_ccountrygroup ad_client_id adempiere.c_countrygroup ad_client_id
39 adclient_ccountrygroupcountry ad_client_id adempiere.c_countrygroupcountry ad_client_id
40 adclient_ccountrygrouptrl ad_client_id adempiere.c_countrygroup_trl ad_client_id
41 adclient_celement ad_client_id adempiere.c_element ad_client_id
42 adclient_celementvalue ad_client_id adempiere.c_elementvalue ad_client_id
43 adclient_clocation ad_client_id adempiere.c_location ad_client_id
44 adclient_cordersource ad_client_id adempiere.c_ordersource ad_client_id
45 adclient_cproject ad_client_id adempiere.c_project ad_client_id
46 adclient_crecurringgroup ad_client_id adempiere.c_recurringgroup ad_client_id
47 adclient_cregiontrl ad_client_id adempiere.c_region_trl ad_client_id
48 adclient_csalesregiontrl ad_client_id adempiere.c_salesregion_trl ad_client_id
49 adclient_csalesstagetrl ad_client_id adempiere.c_salesstage_trl ad_client_id
50 adclient_ctaxprovider ad_client_id adempiere.c_taxprovider ad_client_id
51 adclient_glcategorytrl ad_client_id adempiere.gl_category_trl ad_client_id
52 adclient_gljournalline ad_client_id adempiere.gl_journalline ad_client_id
53 adclient_mcost ad_client_id adempiere.m_cost ad_client_id
54 adclient_mcostdetail ad_client_id adempiere.m_costdetail ad_client_id
55 adclient_mlocatortype ad_client_id adempiere.m_locatortype ad_client_id
56 adclient_mpricelisttrl ad_client_id adempiere.m_pricelist_trl ad_client_id
57 adclient_mpricelistversiontrl ad_client_id adempiere.m_pricelist_version_trl ad_client_id
58 adclient_mproduct ad_client_id adempiere.m_product ad_client_id
59 adclient_mproductcategorytrl ad_client_id adempiere.m_product_category_trl ad_client_id
60 adclient_padashboardcontentacc ad_client_id adempiere.pa_dashboardcontent_access ad_client_id
61 adclient_vc ad_client_id adempiere.c_validcombination ad_client_id
62 adclient_wstore ad_client_id adempiere.w_store ad_client_id
63 c_buspartner_locationclient ad_client_id adempiere.c_bpartner_location ad_client_id
64 c_calendarclient ad_client_id adempiere.c_calendar ad_client_id
65 c_cityclient ad_client_id adempiere.c_city ad_client_id
66 c_conversion_rateclient ad_client_id adempiere.c_conversion_rate ad_client_id
67 c_countryclient ad_client_id adempiere.c_country ad_client_id
68 c_currencyclient ad_client_id adempiere.c_currency ad_client_id
69 c_nonbusinesdaysclient ad_client_id adempiere.c_nonbusinessday ad_client_id
70 c_periodclient ad_client_id adempiere.c_period ad_client_id
71 c_regionclient ad_client_id adempiere.c_region ad_client_id
72 c_uom_conversionclient ad_client_id adempiere.c_uom_conversion ad_client_id
73 c_uomclient ad_client_id adempiere.c_uom ad_client_id
74 c_yearclient ad_client_id adempiere.c_year ad_client_id
75 columnclient ad_client_id adempiere.ad_column ad_client_id
76 fieldclient ad_client_id adempiere.ad_field ad_client_id
77 languageclient ad_client_id adempiere.ad_language ad_client_id
78 m_productpo_client ad_client_id adempiere.m_product_po ad_client_id
79 m_substitute_client ad_client_id adempiere.m_substitute ad_client_id
80 m_warehouse_client ad_client_id adempiere.m_warehouse ad_client_id
81 m_wh_locator_client ad_client_id adempiere.m_locator ad_client_id
82 messageclient ad_client_id adempiere.ad_message ad_client_id
83 notificationclient_adbroadcast ad_client_id adempiere.ad_broadcastmessage notification_client_id
84 ref_tableclient ad_client_id adempiere.ad_ref_table ad_client_id
85 referenceclient ad_client_id adempiere.ad_reference ad_client_id
86 remoteclient_adreplication ad_client_id adempiere.ad_replication remote_client_id
87 sequence_auditclient ad_client_id adempiere.ad_sequence_audit ad_client_id
88 sequence_noclient ad_client_id adempiere.ad_sequence_no ad_client_id
89 sequenceclient ad_client_id adempiere.ad_sequence ad_client_id
90 tabclient ad_client_id adempiere.ad_tab ad_client_id
91 tableclient ad_client_id adempiere.ad_table ad_client_id
92 taskclient ad_client_id adempiere.ad_task ad_client_id
93 taskinstanceclient ad_client_id adempiere.ad_taskinstance ad_client_id
94 val_ruleclient ad_client_id adempiere.ad_val_rule ad_client_id
95 wf_instanceclient ad_client_id adempiere.ad_wf_process ad_client_id
96 wf_nodeclient ad_client_id adempiere.ad_wf_node ad_client_id
97 wf_nodenextclient ad_client_id adempiere.ad_wf_nodenext ad_client_id
98 windowclient ad_client_id adempiere.ad_window ad_client_id
99 workflowclient ad_client_id adempiere.ad_workflow ad_client_id


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