/* ================================================================================ 档案代号: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; |