/*
================================================================================
档案代号:msd_file
档案名称:MPS 计划变更单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table msd_file
(
msd01       varchar2(16) NOT NULL,   /*MPS 计划变更单号                       */
msd02       number(5) NOT NULL,      /*项次                                   */
msd03       varchar2(16),            /*计划编号                               */
msd04       varchar2(1),             /*变异别                                 */
                                     /*变异别 1.修改 2.新增                   */
msd05       number(5),               /*项次                                   */
msd06       varchar2(40),            /*料号                                   */
msd07       date,                    /*生产日期                               */
msd08       date,                    /*BOM 有效日期                           */
msd09       number(15,3),            /*变更前数量                             */
msd10       number(15,3),            /*变更后数量                             */
msd11       varchar2(40),            /*主料料号                               */
msd12       varchar2(1),             /*变更原因                               */
msd13       varchar2(255)            /*备    注                               */
);

create        index msd_02 on msd_file (msd03);
create        index msd_03 on msd_file (msd06);
create unique index msd_pk on msd_file (msd01,msd02);
alter table msd_file add  constraint msd_pk primary key  (msd01,msd02) enable validate;
grant select on msd_file to public;
grant index on msd_file to public;
grant update on msd_file to public;
grant delete on msd_file to public;
grant insert on msd_file to public;