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