/*
================================================================================
档案代号:gbh_file
档案名称:Window Style (4st) 设定记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gbh_file
(
gbh01 varchar2(25) NOT NULL, /*window style 代码 */
gbh02 varchar2(1), /*windowtype (normal) */
/* 0:not define */
/* 1:normal */
/* 2:modal */
gbh03 varchar2(1), /*windowoptionclose (auto) */
/* 0:not define */
/* 1:auto */
/* 2:yes */
/* 3:no */
gbh04 varchar2(1), /*windowoptionminimize (auto) */
/* 0:not define */
/* 1:auto */
/* 2:yes */
/* 3:no */
gbh05 varchar2(1), /*windowoptionmaximize (auto) */
/* 0:not define */
/* 1:auto */
/* 2:yes */
/* 3:no */
gbh06 varchar2(1), /*windowsystemmenu (auto) */
/* 0:not define */
/* 1:auto */
/* 2:yes */
/* 3:no */
gbh07 varchar2(1), /*sizable (yes) */
/* 0:not define */
/* 1:auto */
/* 2:yes */
/* 3:no */
gbh08 varchar2(1), /*position (default) */
/* 0:not define */
/* 1:default */
/* 2:field */
/* 3:center */
/* 4:center2 */
gbh09 varchar2(1), /*border (normal) */
/* 0:not define */
/* 1:normal */
/* 2:frame */
/* 3:tool */
/* 4:none */
gbh10 varchar2(1), /*actionpanelposition (right) */
/* 0:not define */
/* 1:none */
/* 2:top */
/* 3:left */
/* 4:bottom */
/* 5:right */
gbh11 varchar2(1), /*actionpanelbuttonsize (normal) */
/* 0:not define */
/* 1:normal */
/* 2:srink */
/* 3:tiny */
/* 4:small */
/* 5:medium */
/* 6:large */
/* 7:huge */
gbh12 varchar2(1), /*actionpanelbuttonspace (right) */
/* 0:not define */
/* 1:none */
/* 2:tiny */
/* 3:small */
/* 4:medium */
/* 5:large */
/* 6:huge */
gbh13 varchar2(1), /*ringmenuposition (right) */
/* 0:not define */
/* 1:none */
/* 2:top */
/* 3:left */
/* 4:bottom */
/* 5:right */
gbh14 varchar2(1), /*ringmenubuttonsize (normal) */
/* 0:not define */
/* 1:normal */
/* 2:srink */
/* 3:tiny */
/* 4:small */
/* 5:medium */
/* 6:large */
/* 7:huge */
gbh15 varchar2(1), /*startmenuposition (none) */
/* 0:not define */
/* 1:none */
/* 2:tree */
/* 3:menu */
/* 4:poptree */
gbh16 varchar2(1), /*toolbarposition (top) */
/* 0:not define */
/* 1:none */
/* 2:top */
/* 3:left */
/* 4:bottom */
/* 5:right */
gbh17 varchar2(1), /*statusbartype (default) */
/* 0:not define */
/* 1:default */
/* 2:lines1 */
/* 3:lines2 */
/* 4:lines3 */
/* 5:lines4 */
/* 6:lines5 */
/* 7:lines6 */
/* 8:panels1 */
/* 9:panels2 */
/* a:panels3 */
/* b:panels4 */
/* c:panels5 */
/* d:none */
gbh18 varchar2(1), /*No Use */
gbh19 varchar2(1), /*No Use */
gbh20 varchar2(1), /*No Use */
gbhuser varchar2(10), /*user */
gbhgrup varchar2(10), /*owner group */
gbhmodu varchar2(10), /*modifier */
gbhdate date, /*modify or create date */
gbhacti varchar2(1) /*activity code */
);
create unique index gbh_pk on gbh_file (gbh01);
alter table gbh_file add constraint gbh_pk primary key (gbh01) enable validate;
grant select on gbh_file to public;
grant index on gbh_file to public;
grant update on gbh_file to public;
grant delete on gbh_file to public;
grant insert on gbh_file to public;
|