/*
================================================================================
档案代号:mpw_file
档案名称:销售生产库存计划每日明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table mpw_file
(
mpw00       number(10) NOT NULL,     /*资料序号                               */
                                     /*资料序号 (用此栏位和单头的资料做join)  */
mpw01       date NOT NULL,           /*计划日期                               */
mpw10       number(15,3)             /*当日计划数量                           */
);

create unique index mpw_pk on mpw_file (mpw00,mpw01);
alter table mpw_file add  constraint mpw_pk primary key  (mpw00,mpw01) enable validate;
grant select on mpw_file to public;
grant index on mpw_file to public;
grant update on mpw_file to public;
grant delete on mpw_file to public;
grant insert on mpw_file to public;