/*
================================================================================
档案代号:ppd_file
档案名称:供应商自定义项目评分档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ppd_file
(
ppd01       varchar2(6) NOT NULL,    /*评核年月                               */
ppd02       varchar2(10) NOT NULL,   /*厂商代码                               */
ppd03       varchar2(10) NOT NULL,   /*评核项目代码                           */
ppd04       number(8,4)              /*分数                                   */
);

create unique index ppd_pk on ppd_file (ppd01,ppd02,ppd03);
alter table ppd_file add  constraint ppd_pk primary key  (ppd01,ppd02,ppd03) enable validate;
grant select on ppd_file to public;
grant index on ppd_file to public;
grant update on ppd_file to public;
grant delete on ppd_file to public;
grant insert on ppd_file to public;