/* ================================================================================ 档案代号:pjh_file 档案名称:wbs累计人力需求档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pjh_file ( pjh01 varchar2(30) NOT NULL, /*wbs编码 */ pjh02 varchar2(10) NOT NULL, /*技能代号 */ pjh03 number(15,3) /*需求量 */ ); create unique index pjh_pk on pjh_file (pjh01,pjh02); alter table pjh_file add constraint pjh_pk primary key (pjh01,pjh02) enable validate; grant select on pjh_file to public; grant index on pjh_file to public; grant update on pjh_file to public; grant delete on pjh_file to public; grant insert on pjh_file to public; |