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