/*
================================================================================
档案代号:pjha_file
档案名称:wbs本阶人力需求档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjha_file
(
pjha01      varchar2(30) NOT NULL,   /*本阶wbs编码                            */
pjha02      number(5) NOT NULL,      /*项次                                   */
pjha03      varchar2(10),            /*技能代号                               */
pjha04      number(15,3),            /*需求数量                               */
pjhaacti    varchar2(1),             /*资料有效码                             */
pjhadate    date,                    /*最近修改日                             */
pjhagrup    varchar2(10),            /*资料所有部门                           */
pjhamodu    varchar2(10),            /*资料修改者                             */
pjhauser    varchar2(10)             /*资料所有者                             */
);

create unique index pjha_pk on pjha_file (pjha01,pjha02);
alter table pjha_file add  constraint pjha_pk primary key  (pjha01,pjha02) enable validate;
grant select on pjha_file to public;
grant index on pjha_file to public;
grant update on pjha_file to public;
grant delete on pjha_file to public;
grant insert on pjha_file to public;