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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_client_id numeric(10)  
2 ad_org_id numeric(10)  
3 isactive character(1)  
4 created timestamp without time zone  
5 createdby numeric(10)  
6 updated timestamp without time zone  
7 updatedby numeric(10)  
8 ad_printformat_id numeric(10)  
9 name character varying(60)  
10 description character varying(255)  
11 istablebased character(1)  
12 isform character(1)  
13 ad_table_id numeric(10)  
14 ad_reportview_id numeric(10)  
15 ad_printpaper_id numeric(10)  
16 default_ad_printcolor_id numeric(10)  
17 default_ad_printfont_id numeric(10)  
18 isstandardheaderfooter character(1)  
19 ad_printtableformat_id numeric(10)  
20 headermargin numeric(10)  
21 footermargin numeric(10)  
22 printername character varying(40)  
23 isdefault character(1)  
24 ad_printformatitem_id numeric(10)  
25 itemname character varying(60)  
26 printname character varying(2000)  
27 printnamesuffix character varying(60)  
28 isprinted character(1)  
29 printareatype character(1)  
30 seqno numeric(10)  
31 printformattype character(1)  
32 ad_column_id numeric(10)  
33 ad_printformatchild_id numeric(10)  
34 imageisattached character(1)  
35 imageurl character varying(120)  
36 isrelativeposition character(1)  
37 isnextline character(1)  
38 xspace numeric(10)  
39 yspace numeric(10)  
40 xposition numeric(10)  
41 yposition numeric(10)  
42 maxwidth numeric(10)  
43 isheightoneline character(1)  
44 maxheight numeric(10)  
45 isfixedwidth character(1)  
46 issetnlposition character(1)  
47 issuppressnull character(1)  
48 belowcolumn numeric(10)  
49 fieldalignmenttype character(1)  
50 linealignmenttype character(1)  
51 ad_printcolor_id numeric(10)  
52 ad_printfont_id numeric(10)  
53 isorderby character(1)  
54 sortno numeric(10)  
55 isgroupby character(1)  
56 ispagebreak character(1)  
57 isnextpage character(1)  
58 issummarized character(1)  
59 isaveraged character(1)  
60 iscounted character(1)  
61 ismincalc character(1)  
62 ismaxcalc character(1)  
63 isvariancecalc character(1)  
64 isdeviationcalc character(1)  
65 isrunningtotal character(1)  
66 runningtotallines numeric(10)  
67 ad_printgraph_id numeric(10)  


ソース
ソース 
 SELECT f.ad_client_id,
    f.ad_org_id,
    i.isactive,
    i.created,
    i.createdby,
    i.updated,
    i.updatedby,
    f.ad_printformat_id,
    f.name,
    f.description,
    f.istablebased,
    f.isform,
    f.ad_table_id,
    f.ad_reportview_id,
    f.ad_printpaper_id,
    f.ad_printcolor_id AS default_ad_printcolor_id,
    f.ad_printfont_id AS default_ad_printfont_id,
    f.isstandardheaderfooter,
    f.ad_printtableformat_id,
    f.headermargin,
    f.footermargin,
    f.printername,
    f.isdefault,
    i.ad_printformatitem_id,
    i.name AS itemname,
    i.printname,
    i.printnamesuffix,
    i.isprinted,
    i.printareatype,
    i.seqno,
    i.printformattype,
    i.ad_column_id,
    i.ad_printformatchild_id,
    i.imageisattached,
    i.imageurl,
    i.isrelativeposition,
    i.isnextline,
    i.xspace,
    i.yspace,
    i.xposition,
    i.yposition,
    i.maxwidth,
    i.isheightoneline,
    i.maxheight,
    i.isfixedwidth,
    i.issetnlposition,
    i.issuppressnull,
    i.belowcolumn,
    i.fieldalignmenttype,
    i.linealignmenttype,
    i.ad_printcolor_id,
    i.ad_printfont_id,
    i.isorderby,
    i.sortno,
    i.isgroupby,
    i.ispagebreak,
    i.isnextpage,
    i.issummarized,
    i.isaveraged,
    i.iscounted,
    i.ismincalc,
    i.ismaxcalc,
    i.isvariancecalc,
    i.isdeviationcalc,
    i.isrunningtotal,
    i.runningtotallines,
    i.ad_printgraph_id
   FROM (ad_printformat f
     JOIN ad_printformatitem i ON ((f.ad_printformat_id = i.ad_printformat_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_printformatdetail
3 viewowner adempiere
4 definition SELECT f.ad_client_id,
f.ad_org_id,
i.isactive,
i.created,
i.createdby,
i.updated,
i.updatedby,
f.ad_printformat_id,
f.name,
f.description,
f.istablebased,
f.isform,
f.ad_table_id,
f.ad_reportview_id,
f.ad_printpaper_id,
f.ad_printcolor_id AS default_ad_printcolor_id,
f.ad_printfont_id AS default_ad_printfont_id,
f.isstandardheaderfooter,
f.ad_printtableformat_id,
f.headermargin,
f.footermargin,
f.printername,
f.isdefault,
i.ad_printformatitem_id,
i.name AS itemname,
i.printname,
i.printnamesuffix,
i.isprinted,
i.printareatype,
i.seqno,
i.printformattype,
i.ad_column_id,
i.ad_printformatchild_id,
i.imageisattached,
i.imageurl,
i.isrelativeposition,
i.isnextline,
i.xspace,
i.yspace,
i.xposition,
i.yposition,
i.maxwidth,
i.isheightoneline,
i.maxheight,
i.isfixedwidth,
i.issetnlposition,
i.issuppressnull,
i.belowcolumn,
i.fieldalignmenttype,
i.linealignmenttype,
i.ad_printcolor_id,
i.ad_printfont_id,
i.isorderby,
i.sortno,
i.isgroupby,
i.ispagebreak,
i.isnextpage,
i.issummarized,
i.isaveraged,
i.iscounted,
i.ismincalc,
i.ismaxcalc,
i.isvariancecalc,
i.isdeviationcalc,
i.isrunningtotal,
i.runningtotallines,
i.ad_printgraph_id
FROM (ad_printformat f
JOIN ad_printformatitem i ON ((f.ad_printformat_id = i.ad_printformat_id)));