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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_language character varying(6) Yes (PK)
2 ad_client_id numeric(10) Yes
3 ad_org_id numeric(10) Yes
4 isactive character(1) Yes 'N'
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 languageiso character(2)  
11 countrycode character(2)  
12 isbaselanguage character(1) Yes 'N'
13 issystemlanguage character(1) Yes 'N'
14 processing character(1)  
15 ad_language_id numeric(10) Yes
16 isdecimalpoint character(1)  
17 datepattern character varying(20)  
18 timepattern character varying(20)  
19 ad_language_uu character varying(36)   NULL
20 isloginlocale character(1)   'N'
21 ad_printpaper_id numeric(10)   NULL
22 printname character varying(60) Yes NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 ad_language_pkey ad_language Yes  
2 ad_language_uu_idx ad_language_uu Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 adprintpaper_adlanguage ad_printpaper_id adempiere.ad_printpaper ad_printpaper_id
2 languageclient ad_client_id adempiere.ad_client ad_client_id
3 languageorg ad_org_id adempiere.ad_org ad_org_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 ad_language_ad_element_trl ad_language adempiere.ad_element_trl ad_language
2 ad_language_ad_process_trl ad_language adempiere.ad_process_trl ad_language
3 ad_language_c_buspartner ad_language adempiere.c_bpartner ad_language
4 ad_language_fieldtrl ad_language adempiere.ad_field_trl ad_language
5 ad_language_menutrl ad_language adempiere.ad_menu_trl ad_language
6 ad_language_messagetrl ad_language adempiere.ad_message_trl ad_language
7 ad_language_referencetrl ad_language adempiere.ad_reference_trl ad_language
8 ad_language_reflisttrl ad_language adempiere.ad_ref_list_trl ad_language
9 ad_language_tabtrl ad_language adempiere.ad_tab_trl ad_language
10 ad_language_tasktrl ad_language adempiere.ad_task_trl ad_language
11 ad_language_wfnodetrl ad_language adempiere.ad_wf_node_trl ad_language
12 ad_language_windowtrl ad_language adempiere.ad_window_trl ad_language
13 ad_language_workflowtrl ad_language adempiere.ad_workflow_trl ad_language
14 adlangu_adclient ad_language adempiere.ad_client ad_language
15 adlangu_adctxhelpmsgtrl ad_language adempiere.ad_ctxhelpmsg_trl ad_language
16 adlangu_aderror ad_language adempiere.ad_error ad_language
17 adlangu_aduserdefwin ad_language adempiere.ad_userdef_win ad_language
18 adlangu_cchargetrl ad_language adempiere.c_charge_trl ad_language
19 adlangu_cmnewschannel ad_language adempiere.cm_newschannel ad_language
20 adlangu_ksynonym ad_language adempiere.k_synonym ad_language
21 adlangu_padashboardcontenttrl ad_language adempiere.pa_dashboardcontent_trl ad_language
22 adlangu_pporderbomlinetrl ad_language adempiere.pp_order_bomline_trl ad_language
23 adlangu_pporderbomtrl ad_language adempiere.pp_order_bom_trl ad_language
24 adlangu_ppordernodetrl ad_language adempiere.pp_order_node_trl ad_language
25 adlangu_pporderworkflowtrl ad_language adempiere.pp_order_workflow_trl ad_language
26 adlangu_ppproductbomlinetrl ad_language adempiere.pp_product_bomline_trl ad_language
27 adlangu_ppproductbomtrl ad_language adempiere.pp_product_bom_trl ad_language
28 adlanguage_aassetgrouptrl ad_language adempiere.a_asset_group_trl ad_language
29 adlanguage_adbroadcastmessaget ad_language adempiere.ad_broadcastmessage_trl ad_language
30 adlanguage_adcharttrl ad_language adempiere.ad_chart_trl ad_language
31 adlanguage_adcolortrl ad_language adempiere.ad_color_trl ad_language
32 adlanguage_adcolumntrl ad_language adempiere.ad_column_trl ad_language
33 adlanguage_addesktoptrl ad_language adempiere.ad_desktop_trl ad_language
34 adlanguage_adfieldgrouptrl ad_language adempiere.ad_fieldgroup_trl ad_language
35 adlanguage_adformtrl ad_language adempiere.ad_form_trl ad_language
36 adlanguage_adinfocolumntrl ad_language adempiere.ad_infocolumn_trl ad_language
37 adlanguage_adinfowindowtrl ad_language adempiere.ad_infowindow_trl ad_language
38 adlanguage_adplabellinetrl ad_language adempiere.ad_printlabelline_trl ad_language
39 adlanguage_adprintcolortrl ad_language adempiere.ad_printcolor_trl ad_language
40 adlanguage_adprintformitemtrl ad_language adempiere.ad_printformatitem_trl ad_language
41 adlanguage_adprintformtrl ad_language adempiere.ad_printformat_trl ad_language
42 adlanguage_adprocessparatrl ad_language adempiere.ad_process_para_trl ad_language
43 adlanguage_adtabletrl ad_language adempiere.ad_table_trl ad_language
44 adlanguage_adworkbenchtrl ad_language adempiere.ad_workbench_trl ad_language
45 adlanguage_cactivitytrl ad_language adempiere.c_activity_trl ad_language
46 adlanguage_ccampaigntrl ad_language adempiere.c_campaign_trl ad_language
47 adlanguage_ccountry ad_language adempiere.c_country ad_language
48 adlanguage_ccountrygrouptrl ad_language adempiere.c_countrygroup_trl ad_language
49 adlanguage_ccountrytrl ad_language adempiere.c_country_trl ad_language
50 adlanguage_ccurrencytrl ad_language adempiere.c_currency_trl ad_language
51 adlanguage_cdoctypetrl ad_language adempiere.c_doctype_trl ad_language
52 adlanguage_cdunninglevel ad_language adempiere.c_dunninglevel_trl ad_language
53 adlanguage_celementvaluetrl ad_language adempiere.c_elementvalue_trl ad_language
54 adlanguage_cgreetingtrl ad_language adempiere.c_greeting_trl ad_language
55 adlanguage_cmcontainereletrl ad_language adempiere.cm_container_element_trl ad_language
56 adlanguage_cmcontainertrl ad_language adempiere.cm_container_trl ad_language
57 adlanguage_cmcstageeletrl ad_language adempiere.cm_cstage_element_trl ad_language
58 adlanguage_cmcstagetrl ad_language adempiere.cm_cstage_trl ad_language
59 adlanguage_cpaymenttermtrl ad_language adempiere.c_paymentterm_trl ad_language
60 adlanguage_cregiontrl ad_language adempiere.c_region_trl ad_language
61 adlanguage_csalesregiontrl ad_language adempiere.c_salesregion_trl ad_language
62 adlanguage_csalesstagetrl ad_language adempiere.c_salesstage_trl ad_language
63 adlanguage_ctaxcategorytrl ad_language adempiere.c_taxcategory_trl ad_language
64 adlanguage_ctaxtrl ad_language adempiere.c_tax_trl ad_language
65 adlanguage_cuomtrl ad_language adempiere.c_uom_trl ad_language
66 adlanguage_glcategorytrl ad_language adempiere.gl_category_trl ad_language
67 adlanguage_mpricelisttrl ad_language adempiere.m_pricelist_trl ad_language
68 adlanguage_mpricelistversiontr ad_language adempiere.m_pricelist_version_trl ad_language
69 adlanguage_mproductcategorytrl ad_language adempiere.m_product_category_trl ad_language
70 adlanguage_mproducttrl ad_language adempiere.m_product_trl ad_language
71 adlanguage_rmailtexttrl ad_language adempiere.r_mailtext_trl ad_language
72 adlanguage_wmailmsgtrl ad_language adempiere.w_mailmsg_trl ad_language
73 wstoretrl_adlangauge ad_language adempiere.w_store_trl ad_language


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