/*
================================================================================
档案代号:pjn_file
档案名称:专案里程碑动设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjn_file
(
pjn01       varchar2(10) NOT NULL,   /*专案代号                               */
pjn02       varchar2(4) NOT NULL,    /*里程碑代号                             */
pjn03       varchar2(80),            /*里程碑名称                             */
pjn04       varchar2(1),             /*WBS/活动                               */
pjn05       varchar2(30),            /*WBS/活动                               */
pjn06       number(15,6),            /*目标完工率                             */
pjn07       number(15,6),            /*目标收款率                             */
pjn08       number(15,3),            /*预计完工偏置期(天)                     */
pjn09       varchar2(1),             /*有无触发事件                           */
pjnacti     varchar2(1),             /*资料有效码                             */
pjndate     date,                    /*最近修改日                             */
pjngrup     varchar2(10),            /*资料所有部门                           */
pjnmodu     varchar2(10),            /*资料修改者                             */
pjnuser     varchar2(10)             /*资料所有者                             */
);

create unique index pjn_pk on pjn_file (pjn01,pjn02);
alter table pjn_file add  constraint pjn_pk primary key  (pjn01,pjn02) enable validate;
grant select on pjn_file to public;
grant index on pjn_file to public;
grant update on pjn_file to public;
grant delete on pjn_file to public;
grant insert on pjn_file to public;