/* ================================================================================ 档案代号: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; |