/*
================================================================================
档案代号:ppc_file
档案名称:供应商类别设定评价权数档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ppc_file
(
ppc01       varchar2(10) NOT NULL,   /*厂商类别                               */
ppc02       varchar2(10) NOT NULL,   /*评核项目代码                           */
ppc03       number(15,3)             /*权数                                   */
);

create unique index ppc_pk on ppc_file (ppc01,ppc02);
alter table ppc_file add  constraint ppc_pk primary key  (ppc01,ppc02) enable validate;
grant select on ppc_file to public;
grant index on ppc_file to public;
grant update on ppc_file to public;
grant delete on ppc_file to public;
grant insert on ppc_file to public;