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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 m_warehouse_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 value character varying(40) Yes
10 name character varying(60) Yes
11 description character varying(255)  
12 c_location_id numeric(10) Yes
13 separator character(1) Yes
14 m_warehousesource_id numeric(10)  
15 replenishmentclass character varying(60)  
16 isintransit character(1)   'N'
17 isdisallownegativeinv character(1) Yes 'N'
18 m_warehouse_uu character varying(36)   NULL
19 m_reservelocator_id numeric(10)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 m_warehouse_name ad_client_id,name Yes  
2 m_warehouse_pkey m_warehouse_id Yes  
3 m_warehouse_uu_idx m_warehouse_uu Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 c_location_warehouse c_location_id adempiere.c_location c_location_id
2 m_warehouse_client ad_client_id adempiere.ad_client ad_client_id
3 m_warehouse_org ad_org_id adempiere.ad_org ad_org_id
4 mreservelocator_mwarehouse m_reservelocator_id adempiere.m_locator m_locator_id
5 mwarehousesource_mwarehouse m_warehousesource_id adempiere.m_warehouse m_warehouse_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 dropshipwarehouse_adorginfo m_warehouse_id adempiere.ad_orginfo dropship_warehouse_id
2 m_warehouse_locator m_warehouse_id adempiere.m_locator m_warehouse_id
3 m_warehouse_replenish m_warehouse_id adempiere.m_replenish m_warehouse_id
4 m_warehouse_warehouse_acct m_warehouse_id adempiere.m_warehouse_acct m_warehouse_id
5 mwarehouse_adorginfo m_warehouse_id adempiere.ad_orginfo m_warehouse_id
6 mwarehouse_cbpedi m_warehouse_id adempiere.c_bp_edi m_warehouse_id
7 mwarehouse_corder m_warehouse_id adempiere.c_order m_warehouse_id
8 mwarehouse_corderline m_warehouse_id adempiere.c_orderline m_warehouse_id
9 mwarehouse_cpos m_warehouse_id adempiere.c_pos m_warehouse_id
10 mwarehouse_cproject m_warehouse_id adempiere.c_project m_warehouse_id
11 mwarehouse_ddnetworkdistributi m_warehouse_id adempiere.dd_networkdistributionline m_warehouse_id
12 mwarehouse_ddorder m_warehouse_id adempiere.dd_order m_warehouse_id
13 mwarehouse_iinventory m_warehouse_id adempiere.i_inventory m_warehouse_id
14 mwarehouse_iorder m_warehouse_id adempiere.i_order m_warehouse_id
15 mwarehouse_iproductplanning m_warehouse_id adempiere.i_productplanning m_warehouse_id
16 mwarehouse_medi m_warehouse_id adempiere.m_edi m_warehouse_id
17 mwarehouse_mforecastline m_warehouse_id adempiere.m_forecastline m_warehouse_id
18 mwarehouse_minout m_warehouse_id adempiere.m_inout m_warehouse_id
19 mwarehouse_minventory m_warehouse_id adempiere.m_inventory m_warehouse_id
20 mwarehouse_mperpetualinv m_warehouse_id adempiere.m_perpetualinv m_warehouse_id
21 mwarehouse_mpromotionprecondit m_warehouse_id adempiere.m_promotionprecondition m_warehouse_id
22 mwarehouse_mrequisition m_warehouse_id adempiere.m_requisition m_warehouse_id
23 mwarehouse_mshippingtransactio m_warehouse_id adempiere.m_shippingtransaction m_warehouse_id
24 mwarehouse_mstoragereservation m_warehouse_id adempiere.m_storagereservation m_warehouse_id
25 mwarehouse_ppcostcollector m_warehouse_id adempiere.pp_cost_collector m_warehouse_id
26 mwarehouse_ppmrp m_warehouse_id adempiere.pp_mrp m_warehouse_id
27 mwarehouse_pporder m_warehouse_id adempiere.pp_order m_warehouse_id
28 mwarehouse_pporderbomline m_warehouse_id adempiere.pp_order_bomline m_warehouse_id
29 mwarehouse_ppproductplanning m_warehouse_id adempiere.pp_product_planning m_warehouse_id
30 mwarehouse_sresource m_warehouse_id adempiere.s_resource m_warehouse_id
31 mwarehouse_stimeexpense m_warehouse_id adempiere.s_timeexpense m_warehouse_id
32 mwarehouse_tinventoryvalue m_warehouse_id adempiere.t_inventoryvalue m_warehouse_id
33 mwarehouse_treplenish m_warehouse_id adempiere.t_replenish m_warehouse_id
34 mwarehouse_uposterminal m_warehouse_id adempiere.u_posterminal m_warehouse_id
35 mwarehouse_wstore m_warehouse_id adempiere.w_store m_warehouse_id
36 mwarehousesource_ddnetworkdist m_warehouse_id adempiere.dd_networkdistributionline m_warehousesource_id
37 mwarehousesource_mreplenish m_warehouse_id adempiere.m_replenish m_warehousesource_id
38 mwarehousesource_mwarehouse m_warehouse_id adempiere.m_warehouse m_warehousesource_id
39 mwarehousesource_treplenish m_warehouse_id adempiere.t_replenish m_warehousesource_id


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