/*
================================================================================
档案代号:ppe_file
档案名称:成本交期品质评价分数档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ppe_file
(
ppe01       varchar2(6) NOT NULL,    /*年月                                   */
ppe02       varchar2(10) NOT NULL,   /*厂商编号                               */
ppe03       varchar2(10) NOT NULL,   /*评核项目                               */
ppe04       number(8,4),             /*分数                                   */
ppe05       number(15,3),            /*加权                                   */
ppe06       number(15,3),            /*加权后分数                             */
ppe07       number(15,3),            /*修正后分数                             */
ppedate     date,                    /*最近修改日                             */
ppegrup     varchar2(10),            /*资料所有部门                           */
ppemodu     varchar2(10),            /*资料修改者                             */
ppeuser     varchar2(10)             /*资料所有者                             */
);

create unique index ppe_pk on ppe_file (ppe01,ppe02,ppe03);
alter table ppe_file add  constraint ppe_pk primary key  (ppe01,ppe02,ppe03) enable validate;
grant select on ppe_file to public;
grant index on ppe_file to public;
grant update on ppe_file to public;
grant delete on ppe_file to public;
grant insert on ppe_file to public;