/*
================================================================================
档案代号:zr_file
档案名称:程式档案关连档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zr_file
(
zr01        varchar2(20) NOT NULL,   /*程式编号                               */
zr02        varchar2(15) NOT NULL,   /*档案编号                               */
zr03        varchar2(1) NOT NULL     /*异动别                                 */
                                     /*异动别 (Insert/Update/Delete/Select)   */
);

create unique index zr_pk on zr_file (zr01,zr02,zr03);
alter table zr_file add  constraint zr_pk primary key  (zr01,zr02,zr03) enable validate;
grant select on zr_file to public;
grant index on zr_file to public;
grant update on zr_file to public;
grant delete on zr_file to public;
grant insert on zr_file to public;