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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_campaign_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_channel_id numeric(10)  
13 startdate timestamp without time zone  
14 enddate timestamp without time zone  
15 costs numeric Yes 0
16 issummary character(1) Yes 'N'
17 c_campaign_uu character varying(36)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 c_campaign_pkey c_campaign_id Yes  
2 c_campaign_uu_idx c_campaign_uu Yes  
3 c_campaign_value ad_client_id,value Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 cchannel_ccampaign c_channel_id adempiere.c_channel c_channel_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 ccampaign_aduser c_campaign_id adempiere.ad_user c_campaign_id
2 ccampaign_ccampaigntrl c_campaign_id adempiere.c_campaign_trl c_campaign_id
3 ccampaign_ccash c_campaign_id adempiere.c_cash c_campaign_id
4 ccampaign_ccashplan c_campaign_id adempiere.c_cashplan c_campaign_id
5 ccampaign_ccashplanline c_campaign_id adempiere.c_cashplanline c_campaign_id
6 ccampaign_cinvoice c_campaign_id adempiere.c_invoice c_campaign_id
7 ccampaign_cinvoiceline c_campaign_id adempiere.c_invoiceline c_campaign_id
8 ccampaign_copportunity c_campaign_id adempiere.c_opportunity c_campaign_id
9 ccampaign_corder c_campaign_id adempiere.c_order c_campaign_id
10 ccampaign_corderline c_campaign_id adempiere.c_orderline c_campaign_id
11 ccampaign_cpayment c_campaign_id adempiere.c_payment c_campaign_id
12 ccampaign_cpaymenttransaction c_campaign_id adempiere.c_paymenttransaction c_campaign_id
13 ccampaign_cproject c_campaign_id adempiere.c_project c_campaign_id
14 ccampaign_ddorder c_campaign_id adempiere.dd_order c_campaign_id
15 ccampaign_ddorderline c_campaign_id adempiere.dd_orderline c_campaign_id
16 ccampaign_factacctsummary c_campaign_id adempiere.fact_acct_summary c_campaign_id
17 ccampaign_gldist c_campaign_id adempiere.gl_distribution c_campaign_id
18 ccampaign_gldistline c_campaign_id adempiere.gl_distributionline c_campaign_id
19 ccampaign_gljournalline c_campaign_id adempiere.gl_journalline c_campaign_id
20 ccampaign_hrcontract c_campaign_id adempiere.hr_contract c_campaign_id
21 ccampaign_hrmovement c_campaign_id adempiere.hr_movement c_campaign_id
22 ccampaign_ifajournal c_campaign_id adempiere.i_fajournal c_campaign_id
23 ccampaign_igljournal c_campaign_id adempiere.i_gljournal c_campaign_id
24 ccampaign_iinvoice c_campaign_id adempiere.i_invoice c_campaign_id
25 ccampaign_imovement c_campaign_id adempiere.i_movement c_campaign_id
26 ccampaign_iorder c_campaign_id adempiere.i_order c_campaign_id
27 ccampaign_minout c_campaign_id adempiere.m_inout c_campaign_id
28 ccampaign_minoutline c_campaign_id adempiere.m_inoutline c_campaign_id
29 ccampaign_minventory c_campaign_id adempiere.m_inventory c_campaign_id
30 ccampaign_mmovement c_campaign_id adempiere.m_movement c_campaign_id
31 ccampaign_mproduction c_campaign_id adempiere.m_production c_campaign_id
32 ccampaign_mpromotion c_campaign_id adempiere.m_promotion c_campaign_id
33 ccampaign_pareportcolumn c_campaign_id adempiere.pa_reportcolumn c_campaign_id
34 ccampaign_pareportsource c_campaign_id adempiere.pa_reportsource c_campaign_id
35 ccampaign_ppcostcollector c_campaign_id adempiere.pp_cost_collector c_campaign_id
36 ccampaign_pporder c_campaign_id adempiere.pp_order c_campaign_id
37 ccampaign_rrequest c_campaign_id adempiere.r_request c_campaign_id
38 ccampaign_stimeexpenseline c_campaign_id adempiere.s_timeexpenseline c_campaign_id
39 ccampaign_taging c_campaign_id adempiere.t_aging c_campaign_id
40 so_campaign_fact_acct c_campaign_id adempiere.fact_acct c_campaign_id
41 socampaign_caschemaelement c_campaign_id adempiere.c_acctschema_element c_campaign_id
42 socampaign_vc c_campaign_id adempiere.c_validcombination c_campaign_id


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