/* ================================================================================ 档案代号:ze_file 档案名称:错误讯息档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ze_file ( ze01 varchar2(7) NOT NULL, /*错误讯息代号 */ /*________________________________________*/ ze02 varchar2(1) NOT NULL, /*语言别 */ /*语言别(0/1/2) */ /* 0:中文 */ /* 1:英文 */ ze03 varchar2(1500), /*错误讯息内容 */ ze04 date, /*最后修改日期 */ ze05 varchar2(1) /*非背景作业下强制弹出视窗错 */ ); create unique index ze_pk on ze_file (ze01,ze02); alter table ze_file add constraint ze_pk primary key (ze01,ze02) enable validate; grant select on ze_file to public; grant index on ze_file to public; grant update on ze_file to public; grant delete on ze_file to public; grant insert on ze_file to public; |