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