/*
================================================================================
档案代号:azo_file
档案名称:系统重要资料修改记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table azo_file
(
azo01       varchar2(20),            /*程式编号                               */
                                     /*程式编号 (program code)                */
azo02       varchar2(10),            /*异动人员                               */
azo03       date,                    /*异动日期                               */
azo04       varchar2(10),            /*异动时间                               */
azo05       varchar2(18),            /*异动资料的 KEY VALUE                   */
azo06       varchar2(80)             /*异动说明                               */
);

create        index azo_01 on azo_file (azo01,azo02);
create        index azo_02 on azo_file (azo04);
grant select on azo_file to public;
grant index on azo_file to public;
grant update on azo_file to public;
grant delete on azo_file to public;
grant insert on azo_file to public;