/*
================================================================================
档案代号:zxy_file
档案名称:员工权限资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zxy_file
(
zxy01       varchar2(10) NOT NULL,   /*使用者代号                             */
                                     /*使用者代号,(Login user name)           */
zxy02       varchar2(80),            /*使用者名称                             */
zxy03       varchar2(10) NOT NULL    /*使用营运中心编号                       */
);

create unique index zxy_pk on zxy_file (zxy01,zxy03);
alter table zxy_file add  constraint zxy_pk primary key  (zxy01,zxy03) enable validate;
grant select on zxy_file to public;
grant index on zxy_file to public;
grant update on zxy_file to public;
grant delete on zxy_file to public;
grant insert on zxy_file to public;