/*
================================================================================
档案代号:gae_file
档案名称:画面元件多语言记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gae_file
(
gae01       varchar2(20) NOT NULL,   /*画面档代码                             */
                                     /* 画面档代码                            */
gae02       varchar2(20) NOT NULL,   /*栏位代码                               */
gae03       varchar2(1) NOT NULL,    /*语言别                                 */
                                     /* 语言别                                */
gae04       varchar2(255),           /*栏位名称                               */
gae05       varchar2(1500),          /*栏位说明                               */
gae06       varchar2(4000),          /*求助文件之栏位说明                     */
gae07       varchar2(1),             /*求助文件之已处理码                     */
gae08       varchar2(1),             /*重要栏位                               */
gae09       varchar2(20),            /*范例档案                               */
gae10       date,                    /*异动日期                               */
gae11       varchar2(1) NOT NULL,    /*客制码                                 */
gae12       varchar2(10) DEFAULT 'std' NOT NULL /*行业别*/
);

create unique index gae_pk on gae_file (gae01,gae02,gae03,gae11,gae12);
alter table gae_file add  constraint gae_pk primary key  (gae01,gae02,gae03,gae11,gae12) enable validate;
grant select on gae_file to public;
grant index on gae_file to public;
grant update on gae_file to public;
grant delete on gae_file to public;
grant insert on gae_file to public;