/*
================================================================================
档案代号:ges_file
档案名称:变数基本资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ges_file
(
ges01       varchar2(5) NOT NULL,    /*变数代码                               */
ges02       varchar2(80),            /*变数名称                               */
ges03       varchar2(2),             /*变数性质                               */
ges04       varchar2(255),           /*默认值                                 */
ges05       number(5),               /*小数位数                               */
ges06       varchar2(10),            /*No Use                                 */
ges07       varchar2(10),            /*No Use                                 */
ges08       varchar2(10),            /*No Use                                 */
gesacti     varchar2(1)              /*有效否(y/n)                            */
);

create unique index ges_pk on ges_file (ges01);
alter table ges_file add  constraint ges_pk primary key  (ges01) enable validate;
grant select on ges_file to public;
grant index on ges_file to public;
grant update on ges_file to public;
grant delete on ges_file to public;
grant insert on ges_file to public;