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