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