/*
================================================================================
档案代号:pjfa_file
档案名称:wbs本阶计划材料需求档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjfa_file
(
pjfa01      varchar2(30) NOT NULL,   /*本阶wbs编码                            */
pjfa02      number(5) NOT NULL,      /*项次                                   */
pjfa03      varchar2(40),            /*料件编号                               */
pjfa04      varchar2(120),           /*品名                                   */
pjfa05      number(15,3),            /*需求量                                 */
pjfa06      date,                    /*需求日                                 */
pjfa07      number(15,3),            /*转请购量                               */
pjfaacti    varchar2(1),             /*资料有效码                             */
pjfadate    date,                    /*最近修改日                             */
pjfagrup    varchar2(10),            /*资料所有部门                           */
pjfamodu    varchar2(10),            /*资料修改者                             */
pjfauser    varchar2(10)             /*资料所有者                             */
);

create unique index pjfa_pk on pjfa_file (pjfa01,pjfa02);
alter table pjfa_file add  constraint pjfa_pk primary key  (pjfa01,pjfa02) enable validate;
grant select on pjfa_file to public;
grant index on pjfa_file to public;
grant update on pjfa_file to public;
grant delete on pjfa_file to public;
grant insert on pjfa_file to public;