/*
================================================================================
档案代号:gbs_file
档案名称:画面元件多语言备注记录子档
档案目的:辅助gae_file
上游档案:
下游档案:
============.========================.==========================================
*/
create table gbs_file
(
gbs01       varchar2(20) NOT NULL,   /*程式代号                               */
gbs02       varchar2(20) NOT NULL,   /*栏位代码                               */
gbs03       varchar2(1) NOT NULL,    /*语言别                                 */
gbs04       varchar2(1) NOT NULL,    /*客制码                                 */
gbs05       varchar2(10) DEFAULT 'std' NOT NULL, /*行业别*/
gbs06       varchar2(1500),          /*栏位说明                               */
gbs07       varchar2(4000),          /*求助文件之栏位说明                     */
gbs08       varchar2(1)              /*no use                                 */
);

create unique index gbs_pk on gbs_file (gbs01,gbs02,gbs03,gbs04,gbs05);
alter table gbs_file add  constraint gbs_pk primary key  (gbs01,gbs02,gbs03,gbs04,gbs05) enable validate;
grant select on gbs_file to public;
grant index on gbs_file to public;
grant update on gbs_file to public;
grant delete on gbs_file to public;
grant insert on gbs_file to public;