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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 m_locator_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 m_warehouse_id numeric(10) Yes
11 priorityno numeric(10) Yes
12 isdefault character(1) Yes 'N'
13 x character varying(60)  
14 y character varying(60)  
15 z character varying(60)  
16 m_locator_uu character varying(36)   NULL
17 m_locatortype_id numeric(10)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 m_location_where m_warehouse_id,x,y,z Yes  
2 m_locator_pkey m_locator_id Yes  
3 m_locator_uu_idx m_locator_uu Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 m_warehouse_locator m_warehouse_id adempiere.m_warehouse m_warehouse_id
2 m_wh_locator_client ad_client_id adempiere.ad_client ad_client_id
3 m_wh_locator_org ad_org_id adempiere.ad_org ad_org_id
4 mlocatortype_mlocator m_locatortype_id adempiere.m_locatortype m_locatortype_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 mlocator_aasset m_locator_id adempiere.a_asset m_locator_id
2 mlocator_aassetaddition m_locator_id adempiere.a_asset_addition m_locator_id
3 mlocator_aassetproduct m_locator_id adempiere.a_asset_product m_locator_id
4 mlocator_cprojectissue m_locator_id adempiere.c_projectissue m_locator_id
5 mlocator_ddorderline m_locator_id adempiere.dd_orderline m_locator_id
6 mlocator_factacct m_locator_id adempiere.fact_acct m_locator_id
7 mlocator_iasset m_locator_id adempiere.i_asset m_locator_id
8 mlocator_ifixedasset m_locator_id adempiere.i_fixedasset m_locator_id
9 mlocator_iinventory m_locator_id adempiere.i_inventory m_locator_id
10 mlocator_imovement m_locator_id adempiere.i_movement m_locator_id
11 mlocator_minoutline m_locator_id adempiere.m_inoutline m_locator_id
12 mlocator_minventorycount m_locator_id adempiere.m_transaction m_locator_id
13 mlocator_minventoryline m_locator_id adempiere.m_inventoryline m_locator_id
14 mlocator_movementline m_locator_id adempiere.m_movementline m_locatorto_id
15 mlocator_mproduct m_locator_id adempiere.m_product m_locator_id
16 mlocator_mproduction m_locator_id adempiere.m_production m_locator_id
17 mlocator_mproductionline m_locator_id adempiere.m_productionline m_locator_id
18 mlocator_mproductionplan m_locator_id adempiere.m_productionplan m_locator_id
19 mlocator_mreplenish m_locator_id adempiere.m_replenish m_locator_id
20 mlocator_mstorageonhand m_locator_id adempiere.m_storageonhand m_locator_id
21 mlocator_ppcostcollector m_locator_id adempiere.pp_cost_collector m_locator_id
22 mlocator_pporderbomline m_locator_id adempiere.pp_order_bomline m_locator_id
23 mlocator_ttransaction m_locator_id adempiere.t_transaction m_locator_id
24 mlocatorto_ddorderline m_locator_id adempiere.dd_orderline m_locatorto_id
25 mlocatorto_imovement m_locator_id adempiere.i_movement m_locatorto_id
26 mlocatorto_mmovementline m_locator_id adempiere.m_movementline m_locator_id
27 mreservelocator_mwarehouse m_locator_id adempiere.m_warehouse m_reservelocator_id


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