/*
================================================================================
档案代号:msw_file
档案名称:多营运中心mrp版本档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table msw_file
(
msw000      varchar2(10) NOT NULL,   /*汇总版本号                             */
msw02       number(5),               /*pr/po 允许交期提前 (reschedule)        */
msw03       date,                    /*执行日期                               */
msw04       varchar2(5),             /*起始时间                               */
msw05       varchar2(5),             /*结束时间                               */
msw06       number(10),              /*no use                                 */
msw07       varchar2(10),            /*产生人员                               */
msw08       varchar2(10) NOT NULL,   /*分营运中心代号                         */
msw09       varchar2(2),             /*no use                                 */
msw10       varchar2(20)             /*分营运中心mrp版本号                    */
);

create unique index msw_pk on msw_file (msw000,msw08);
alter table msw_file add  constraint msw_pk primary key  (msw000,msw08) enable validate;
grant select on msw_file to public;
grant index on msw_file to public;
grant update on msw_file to public;
grant delete on msw_file to public;
grant insert on msw_file to public;