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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_language character varying(6)  
2 ad_window_id numeric(10)  
3 ad_tab_id numeric(10)  
4 ad_field_id numeric(10)  
5 ad_table_id numeric(10)  
6 ad_column_id numeric(10)  
7 name character varying(60)  
8 description character varying(255)  
9 help character varying(2000)  
10 isdisplayed character(1)  
11 displaylogic character varying(2000)  
12 displaylength numeric(10)  
13 seqno numeric(10)  
14 sortno numeric(10)  
15 issameline character(1)  
16 isheading character(1)  
17 isfieldonly character(1)  
18 isreadonly character(1)  
19 isencryptedfield character(1)  
20 obscuretype character(3)  
21 columnname character varying(30)  
22 columnsql character varying(2000)  
23 fieldlength numeric(10)  
24 vformat character varying(60)  
25 defaultvalue character varying(2000)  
26 iskey character(1)  
27 isparent character(1)  
28 ismandatory character(1)  
29 isidentifier character(1)  
30 istranslated character(1)  
31 ad_reference_value_id numeric(10)  
32 callout character varying(255)  
33 ad_reference_id numeric(10)  
34 ad_val_rule_id numeric(10)  
35 ad_process_id numeric(10)  
36 isalwaysupdateable character(1)  
37 readonlylogic character varying(2000)  
38 mandatorylogic character varying(2000)  
39 isupdateable character(1)  
40 isencryptedcolumn character(1)  
41 isselectioncolumn character(1)  
42 tablename character varying(40)  
43 valuemin character varying(20)  
44 valuemax character varying(20)  
45 fieldgroup character varying(60)  
46 validationcode character varying(2000)  
47 included_tab_id numeric(10)  
48 fieldgrouptype character(1)  
49 iscollapsedbydefault character(1)  
50 infofactoryclass character varying(255)  
51 isautocomplete character(1)  
52 isallowcopy character(1)  
53 isdisplayedgrid character(1)  
54 seqnogrid numeric(10)  
55 seqnoselection numeric(10)  
56 xposition numeric(10)  
57 columnspan numeric(10)  
58 numlines numeric(10)  
59 istoolbarbutton character(1)  
60 formatpattern character varying(22)  
61 isadvancedfield character(1)  
62 isdefaultfocus character(1)  
63 ad_chart_id numeric(10)  


ソース
ソース 
 SELECT trl.ad_language,
    t.ad_window_id,
    f.ad_tab_id,
    f.ad_field_id,
    tbl.ad_table_id,
    f.ad_column_id,
    trl.name,
    trl.description,
    trl.help,
    f.isdisplayed,
    f.displaylogic,
    f.displaylength,
    f.seqno,
    f.sortno,
    f.issameline,
    f.isheading,
    f.isfieldonly,
    f.isreadonly,
    f.isencrypted AS isencryptedfield,
    f.obscuretype,
    c.columnname,
    c.columnsql,
    c.fieldlength,
    c.vformat,
    COALESCE(f.defaultvalue, c.defaultvalue) AS defaultvalue,
    c.iskey,
    c.isparent,
    COALESCE(f.ismandatory, c.ismandatory) AS ismandatory,
    c.isidentifier,
    c.istranslated,
    COALESCE(f.ad_reference_value_id, c.ad_reference_value_id) AS ad_reference_value_id,
    c.callout,
    COALESCE(f.ad_reference_id, c.ad_reference_id) AS ad_reference_id,
    COALESCE(f.ad_val_rule_id, c.ad_val_rule_id) AS ad_val_rule_id,
    c.ad_process_id,
    COALESCE(f.isalwaysupdateable, c.isalwaysupdateable) AS isalwaysupdateable,
    COALESCE(f.readonlylogic, c.readonlylogic) AS readonlylogic,
    COALESCE(f.mandatorylogic, c.mandatorylogic) AS mandatorylogic,
    COALESCE(f.isupdateable, c.isupdateable) AS isupdateable,
    c.isencrypted AS isencryptedcolumn,
    c.isselectioncolumn,
    tbl.tablename,
    c.valuemin,
    c.valuemax,
    fgt.name AS fieldgroup,
    vr.code AS validationcode,
    f.included_tab_id,
    fg.fieldgrouptype,
    fg.iscollapsedbydefault,
    COALESCE(f.infofactoryclass, c.infofactoryclass) AS infofactoryclass,
    c.isautocomplete,
    COALESCE(f.isallowcopy, c.isallowcopy) AS isallowcopy,
    f.isdisplayedgrid,
    f.seqnogrid,
    c.seqnoselection,
    f.xposition,
    f.columnspan,
    f.numlines,
    COALESCE(f.istoolbarbutton, c.istoolbarbutton) AS istoolbarbutton,
    c.formatpattern,
    f.isadvancedfield,
    f.isdefaultfocus,
    c.ad_chart_id
   FROM (((((((ad_field f
     JOIN ad_field_trl trl ON ((f.ad_field_id = trl.ad_field_id)))
     JOIN ad_tab t ON ((f.ad_tab_id = t.ad_tab_id)))
     LEFT JOIN ad_fieldgroup fg ON ((f.ad_fieldgroup_id = fg.ad_fieldgroup_id)))
     LEFT JOIN ad_fieldgroup_trl fgt ON (((f.ad_fieldgroup_id = fgt.ad_fieldgroup_id) AND ((trl.ad_language)::text = (fgt.ad_language)::text))))
     LEFT JOIN ad_column c ON ((f.ad_column_id = c.ad_column_id)))
     JOIN ad_table tbl ON ((c.ad_table_id = tbl.ad_table_id)))
     LEFT JOIN ad_val_rule vr ON ((vr.ad_val_rule_id = COALESCE(f.ad_val_rule_id, c.ad_val_rule_id))))
  WHERE ((f.isactive = 'Y'::bpchar) AND (c.isactive = 'Y'::bpchar));


インデックス情報
No インデックス名 カラムリスト ユニーク 備考


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname ad_field_vt
3 viewowner adempiere
4 definition SELECT trl.ad_language,
t.ad_window_id,
f.ad_tab_id,
f.ad_field_id,
tbl.ad_table_id,
f.ad_column_id,
trl.name,
trl.description,
trl.help,
f.isdisplayed,
f.displaylogic,
f.displaylength,
f.seqno,
f.sortno,
f.issameline,
f.isheading,
f.isfieldonly,
f.isreadonly,
f.isencrypted AS isencryptedfield,
f.obscuretype,
c.columnname,
c.columnsql,
c.fieldlength,
c.vformat,
COALESCE(f.defaultvalue, c.defaultvalue) AS defaultvalue,
c.iskey,
c.isparent,
COALESCE(f.ismandatory, c.ismandatory) AS ismandatory,
c.isidentifier,
c.istranslated,
COALESCE(f.ad_reference_value_id, c.ad_reference_value_id) AS ad_reference_value_id,
c.callout,
COALESCE(f.ad_reference_id, c.ad_reference_id) AS ad_reference_id,
COALESCE(f.ad_val_rule_id, c.ad_val_rule_id) AS ad_val_rule_id,
c.ad_process_id,
COALESCE(f.isalwaysupdateable, c.isalwaysupdateable) AS isalwaysupdateable,
COALESCE(f.readonlylogic, c.readonlylogic) AS readonlylogic,
COALESCE(f.mandatorylogic, c.mandatorylogic) AS mandatorylogic,
COALESCE(f.isupdateable, c.isupdateable) AS isupdateable,
c.isencrypted AS isencryptedcolumn,
c.isselectioncolumn,
tbl.tablename,
c.valuemin,
c.valuemax,
fgt.name AS fieldgroup,
vr.code AS validationcode,
f.included_tab_id,
fg.fieldgrouptype,
fg.iscollapsedbydefault,
COALESCE(f.infofactoryclass, c.infofactoryclass) AS infofactoryclass,
c.isautocomplete,
COALESCE(f.isallowcopy, c.isallowcopy) AS isallowcopy,
f.isdisplayedgrid,
f.seqnogrid,
c.seqnoselection,
f.xposition,
f.columnspan,
f.numlines,
COALESCE(f.istoolbarbutton, c.istoolbarbutton) AS istoolbarbutton,
c.formatpattern,
f.isadvancedfield,
f.isdefaultfocus,
c.ad_chart_id
FROM (((((((ad_field f
JOIN ad_field_trl trl ON ((f.ad_field_id = trl.ad_field_id)))
JOIN ad_tab t ON ((f.ad_tab_id = t.ad_tab_id)))
LEFT JOIN ad_fieldgroup fg ON ((f.ad_fieldgroup_id = fg.ad_fieldgroup_id)))
LEFT JOIN ad_fieldgroup_trl fgt ON (((f.ad_fieldgroup_id = fgt.ad_fieldgroup_id) AND ((trl.ad_language)::text = (fgt.ad_language)::text))))
LEFT JOIN ad_column c ON ((f.ad_column_id = c.ad_column_id)))
JOIN ad_table tbl ON ((c.ad_table_id = tbl.ad_table_id)))
LEFT JOIN ad_val_rule vr ON ((vr.ad_val_rule_id = COALESCE(f.ad_val_rule_id, c.ad_val_rule_id))))
WHERE ((f.isactive = 'Y'::bpchar) AND (c.isactive = 'Y'::bpchar));