/*
================================================================================
档案代号:zi_file
档案名称:批次执行指令资料主档    BATCH INSTRU
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zi_file
(
zi01        varchar2(10) NOT NULL,   /*批次编号                               */
zi02        varchar2(36),            /*批次编号名称                           */
zi03        date,                    /*失效日期                               */
zi04        date,                    /*最近执行日期                           */
zi05        varchar2(255),           /*备注                                   */
ziacti      varchar2(1),             /*资料有效码                             */
ziuser      varchar2(10),            /*资料所有者                             */
zigrup      varchar2(10),            /*资料所有部门                           */
zimodu      varchar2(10),            /*资料修改者                             */
zidate      date                     /*最近修改日                             */
);

create unique index zi_pk on zi_file (zi01);
alter table zi_file add  constraint zi_pk primary key  (zi01) enable validate;
grant select on zi_file to public;
grant index on zi_file to public;
grant update on zi_file to public;
grant delete on zi_file to public;
grant insert on zi_file to public;