/*
================================================================================
档案代号:msm_file
档案名称:备料指定送货地点档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table msm_file
(
msm01       varchar2(40) NOT NULL,   /*料号                                   */
msm02       varchar2(10) NOT NULL,   /*地址代号                               */
msm03       varchar2(10) NOT NULL,   /*仓库代号                               */
msm04       varchar2(20),            /*储位                                   */
msm05       varchar2(24),            /*批号                                   */
msm06       varchar2(10) NOT NULL,   /*生产部门                               */
msm07       varchar2(255)            /*备注                                   */
);

create unique index msm_pk on msm_file (msm01,msm06);
alter table msm_file add  constraint msm_pk primary key  (msm01,msm06) enable validate;
grant select on msm_file to public;
grant index on msm_file to public;
grant update on msm_file to public;
grant delete on msm_file to public;
grant insert on msm_file to public;