/* ================================================================================ 档案代号:pjha_file 档案名称:wbs本阶人力需求档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pjha_file ( pjha01 varchar2(30) NOT NULL, /*本阶wbs编码 */ pjha02 number(5) NOT NULL, /*项次 */ pjha03 varchar2(10), /*技能代号 */ pjha04 number(15,3), /*需求数量 */ pjhaacti varchar2(1), /*资料有效码 */ pjhadate date, /*最近修改日 */ pjhagrup varchar2(10), /*资料所有部门 */ pjhamodu varchar2(10), /*资料修改者 */ pjhauser varchar2(10) /*资料所有者 */ ); create unique index pjha_pk on pjha_file (pjha01,pjha02); alter table pjha_file add constraint pjha_pk primary key (pjha01,pjha02) enable validate; grant select on pjha_file to public; grant index on pjha_file to public; grant update on pjha_file to public; grant delete on pjha_file to public; grant insert on pjha_file to public; |