/*
================================================================================
档案代号:pjh_file
档案名称:wbs累计人力需求档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjh_file
(
pjh01       varchar2(30) NOT NULL,   /*wbs编码                                */
pjh02       varchar2(10) NOT NULL,   /*技能代号                               */
pjh03       number(15,3)             /*需求量                                 */
);

create unique index pjh_pk on pjh_file (pjh01,pjh02);
alter table pjh_file add  constraint pjh_pk primary key  (pjh01,pjh02) enable validate;
grant select on pjh_file to public;
grant index on pjh_file to public;
grant update on pjh_file to public;
grant delete on pjh_file to public;
grant insert on pjh_file to public;