/*
================================================================================
档案代号:pjhb_file
档案名称:专案活动人力需求档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjhb_file
(
pjhb01      varchar2(10) NOT NULL,   /*网络代号                               */
pjhb02      varchar2(4) NOT NULL,    /*活动代号                               */
pjhb03      number(5) NOT NULL,      /*项次                                   */
pjhb04      varchar2(10),            /*技能代号                               */
pjhb05      number(15,3),            /*需求数量                               */
pjhbacti    varchar2(1),             /*资料有效码                             */
pjhbdate    date,                    /*最近修改日                             */
pjhbgrup    varchar2(10),            /*资料所有部门                           */
pjhbmodu    varchar2(10),            /*资料修改者                             */
pjhbuser    varchar2(10)             /*资料所有者                             */
);

create unique index pjhb_pk on pjhb_file (pjhb01,pjhb02,pjhb03);
alter table pjhb_file add  constraint pjhb_pk primary key  (pjhb01,pjhb02,pjhb03) enable validate;
grant select on pjhb_file to public;
grant index on pjhb_file to public;
grant update on pjhb_file to public;
grant delete on pjhb_file to public;
grant insert on pjhb_file to public;