/*
================================================================================
档案代号:ppa_file
档案名称:供应商评核项目明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ppa_file
(
ppa01       number(5) NOT NULL,      /*项次                                   */
ppa02       varchar2(10) NOT NULL,   /*评核项目代码                           */
ppa03       varchar2(80)             /*评核项目说明                           */
);

create unique index ppa_pk on ppa_file (ppa01,ppa02);
alter table ppa_file add  constraint ppa_pk primary key  (ppa01,ppa02) enable validate;
grant select on ppa_file to public;
grant index on ppa_file to public;
grant update on ppa_file to public;
grant delete on ppa_file to public;
grant insert on ppa_file to public;