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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_project_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 note character varying(2000)  
13 issummary character(1) Yes 'N'
14 ad_user_id numeric(10)  
15 c_bpartner_id numeric(10)  
16 c_bpartner_location_id numeric(10)  
17 poreference character varying(20)  
18 c_paymentterm_id numeric(10)  
19 c_currency_id numeric(10) Yes
20 m_pricelist_version_id numeric(10)  
21 c_campaign_id numeric(10)  
22 iscommitment character(1) Yes 'Y'
23 plannedamt numeric Yes 0
24 plannedqty numeric Yes 0
25 plannedmarginamt numeric Yes 0
26 committedamt numeric Yes 0
27 datecontract timestamp without time zone  
28 datefinish timestamp without time zone  
29 generateto character(1)  
30 processed character(1) Yes 'N'
31 salesrep_id numeric(10)  
32 copyfrom character(1)  
33 c_projecttype_id numeric(10)  
34 committedqty numeric Yes 0
35 invoicedamt numeric Yes 0
36 invoicedqty numeric Yes 0
37 projectbalanceamt numeric Yes 0
38 c_phase_id numeric(10)  
39 iscommitceiling character(1) Yes 'N'
40 m_warehouse_id numeric(10)  
41 projectcategory character(1)   'N'
42 processing character(1)  
43 c_bpartnersr_id numeric(10)  
44 projinvoicerule character(1) Yes '-'
45 projectlinelevel character(1) Yes 'P'
46 c_project_uu character varying(36)   NULL
47 ad_orgtrx_id numeric(10)   NULL
48 c_activity_id numeric(10)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 c_project_pkey c_project_id Yes  
2 c_project_uu_idx c_project_uu Yes  
3 c_project_value ad_client_id,value Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 adclient_cproject ad_client_id adempiere.ad_client ad_client_id
2 adorg_cproject ad_org_id adempiere.ad_org ad_org_id
3 adorgtrx_cproject ad_orgtrx_id adempiere.ad_org ad_org_id
4 aduser_cproject ad_user_id adempiere.ad_user ad_user_id
5 aduser_sr_cproject salesrep_id adempiere.ad_user ad_user_id
6 cactivity_cproject c_activity_id adempiere.c_activity c_activity_id
7 cbpartner_cproject c_bpartner_id adempiere.c_bpartner c_bpartner_id
8 cbpartnersr_cproject c_bpartnersr_id adempiere.c_bpartner c_bpartner_id
9 cbplocation_cproject c_bpartner_location_id adempiere.c_bpartner_location c_bpartner_location_id
10 ccampaign_cproject c_campaign_id adempiere.c_campaign c_campaign_id
11 ccurrency_cproject c_currency_id adempiere.c_currency c_currency_id
12 cpaymentterm_cproject c_paymentterm_id adempiere.c_paymentterm c_paymentterm_id
13 cphase_cproject c_phase_id adempiere.c_phase c_phase_id
14 cprojecttype_cproject c_projecttype_id adempiere.c_projecttype c_projecttype_id
15 mpricelistversion_cproject m_pricelist_version_id adempiere.m_pricelist_version m_pricelist_version_id
16 mwarehouse_cproject m_warehouse_id adempiere.m_warehouse m_warehouse_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 c_project_fact_acct c_project_id adempiere.fact_acct c_project_id
2 c_project_projectacct c_project_id adempiere.c_project_acct c_project_id
3 cproject_aasset c_project_id adempiere.a_asset c_project_id
4 cproject_aassetaddition c_project_id adempiere.a_asset_addition c_project_id
5 cproject_caschemaelement c_project_id adempiere.c_acctschema_element c_project_id
6 cproject_ccash c_project_id adempiere.c_cash c_project_id
7 cproject_ccashplan c_project_id adempiere.c_cashplan c_project_id
8 cproject_ccashplanline c_project_id adempiere.c_cashplanline c_project_id
9 cproject_cinvoice c_project_id adempiere.c_invoice c_project_id
10 cproject_cinvoicebatchline c_project_id adempiere.c_invoicebatchline c_project_id
11 cproject_cinvoiceline c_project_id adempiere.c_invoiceline c_project_id
12 cproject_corder c_project_id adempiere.c_order c_project_id
13 cproject_corderline c_project_id adempiere.c_orderline c_project_id
14 cproject_cpayment c_project_id adempiere.c_payment c_project_id
15 cproject_cpaymenttransaction c_project_id adempiere.c_paymenttransaction c_project_id
16 cproject_cprojectissue c_project_id adempiere.c_projectissue c_project_id
17 cproject_cprojectline c_project_id adempiere.c_projectline c_project_id
18 cproject_cprojectphase c_project_id adempiere.c_projectphase c_project_id
19 cproject_crecurring c_project_id adempiere.c_recurring c_project_id
20 cproject_crecurringrun c_project_id adempiere.c_recurring_run c_project_id
21 cproject_ddorder c_project_id adempiere.dd_order c_project_id
22 cproject_ddorderline c_project_id adempiere.dd_orderline c_project_id
23 cproject_factacctsummary c_project_id adempiere.fact_acct_summary c_project_id
24 cproject_gldist c_project_id adempiere.gl_distribution c_project_id
25 cproject_gldistline c_project_id adempiere.gl_distributionline c_project_id
26 cproject_gljournalline c_project_id adempiere.gl_journalline c_project_id
27 cproject_hrcontract c_project_id adempiere.hr_contract c_project_id
28 cproject_hrmovement c_project_id adempiere.hr_movement c_project_id
29 cproject_ifajournal c_project_id adempiere.i_fajournal c_project_id
30 cproject_igljournal c_project_id adempiere.i_gljournal c_project_id
31 cproject_iinvoice c_project_id adempiere.i_invoice c_project_id
32 cproject_imovement c_project_id adempiere.i_movement c_project_id
33 cproject_iorder c_project_id adempiere.i_order c_project_id
34 cproject_minout c_project_id adempiere.m_inout c_project_id
35 cproject_minoutline c_project_id adempiere.m_inoutline c_project_id
36 cproject_minventory c_project_id adempiere.m_inventory c_project_id
37 cproject_mmovement c_project_id adempiere.m_movement c_project_id
38 cproject_mproduction c_project_id adempiere.m_production c_project_id
39 cproject_pareportcolumn c_project_id adempiere.pa_reportcolumn c_project_id
40 cproject_pareportsource c_project_id adempiere.pa_reportsource c_project_id
41 cproject_ppcostcollector c_project_id adempiere.pp_cost_collector c_project_id
42 cproject_pporder c_project_id adempiere.pp_order c_project_id
43 cproject_rissueproject c_project_id adempiere.r_issueproject c_project_id
44 cproject_rrequest c_project_id adempiere.r_request c_project_id
45 cproject_rrequestaction c_project_id adempiere.r_requestaction c_project_id
46 cproject_stimeexpenseline c_project_id adempiere.s_timeexpenseline c_project_id
47 cproject_taging c_project_id adempiere.t_aging c_project_id
48 cproject_vc c_project_id adempiere.c_validcombination c_project_id


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