/* ================================================================================ 档案代号:pjm_file 档案名称:wbs累计设备需求档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pjm_file ( pjm01 varchar2(30) NOT NULL, /*WBS编码 */ pjm02 varchar2(10) NOT NULL, /*设备类型 */ pjm03 number(10), /*台数 */ pjm04 number(15,3) /*需求量 */ ); create unique index pjm_pk on pjm_file (pjm01,pjm02); alter table pjm_file add constraint pjm_pk primary key (pjm01,pjm02) enable validate; grant select on pjm_file to public; grant index on pjm_file to public; grant update on pjm_file to public; grant delete on pjm_file to public; grant insert on pjm_file to public; |