/* ================================================================================ 档案代号:pjf_file 档案名称:wbs累计材料需求档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pjf_file ( pjf01 varchar2(30) NOT NULL, /*wbs编码 */ pjf02 number(5) NOT NULL, /*项次 */ pjf03 varchar2(40), /*料件编号 */ pjf04 varchar2(120), /*品名 */ pjf05 number(15,3), /*需求量 */ pjf06 date, /*需求日期 */ pjf07 number(15,3) /*转请购量 */ ); create unique index pjf_pk on pjf_file (pjf01,pjf02); alter table pjf_file add constraint pjf_pk primary key (pjf01,pjf02) enable validate; grant select on pjf_file to public; grant index on pjf_file to public; grant update on pjf_file to public; grant delete on pjf_file to public; grant insert on pjf_file to public; |