/*
================================================================================
档案代号:mmn_file
档案名称:开发执行单其它费用资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table mmn_file
(
mmn01       varchar2(16) NOT NULL,   /*开发执行单编号                         */
                                     /*开发执行单编号(开发案号)(mmg01)        */
mmn02       varchar2(16) NOT NULL,   /*执行工单编号                           */
                                     /*执行工单编号(mmg02)                    */
mmn03       number(5) NOT NULL,      /*项次                                   */
mmn04       varchar2(80),            /*费用说明                               */
mmn05       number(20,6)             /*金额                                   */
);

create unique index mmn_pk on mmn_file (mmn01,mmn02,mmn03);
alter table mmn_file add  constraint mmn_pk primary key  (mmn01,mmn02,mmn03) enable validate;
grant select on mmn_file to public;
grant index on mmn_file to public;
grant update on mmn_file to public;
grant delete on mmn_file to public;
grant insert on mmn_file to public;