/*
================================================================================
档案代号:gai_file
档案名称:流程讯息批次通知纪录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gai_file
(
gai01       varchar2(35) NOT NULL,   /*讯息号码                               */
                                     /*讯息号码($模组别_单据编号_三位流水号)  */
gai02       varchar2(1),             /*等级                                   */
                                     /*等级(A.紧急 B.重要 C.一般 D.通知 E.纪录)*/
gai03       varchar2(255),           /*讯息内容                               */
                                     /*讯息内容(应该要包含程式代号与功能类别) */
gai04       varchar2(20),            /*建议执行程式代号                       */
gai05       varchar2(255),           /*Mail收件者清单                         */
                                     /*Mail收件者清单(以分号隔开)             */
gai06       varchar2(255)            /*Mail副本清单                           */
                                     /*Mail副本清单(以分号隔开)               */
);

create unique index gai_pk on gai_file (gai01);
alter table gai_file add  constraint gai_pk primary key  (gai01) enable validate;
grant select on gai_file to public;
grant index on gai_file to public;
grant update on gai_file to public;
grant delete on gai_file to public;
grant insert on gai_file to public;