/*
================================================================================
档案代号:xmh_file
档案名称:客户分类产品分类折扣档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table xmh_file
(
xmh01       varchar2(10) NOT NULL,   /*客户分类                               */
xmh02       varchar2(10) NOT NULL,   /*产品分类                               */
xmh03       number(9,4),             /*折扣                                   */
xmh04       varchar2(1),             /*是否有效                               */
xmhuser     varchar2(10),            /*资料所有者                             */
xmhgrup     varchar2(10),            /*资料所有部门                           */
xmhmodu     varchar2(10),            /*资料修改者                             */
xmhdate     date                     /*最近修改日                             */
);

create unique index xmh_pk on xmh_file (xmh01,xmh02);
alter table xmh_file add  constraint xmh_pk primary key  (xmh01,xmh02) enable validate;
grant select on xmh_file to public;
grant index on xmh_file to public;
grant update on xmh_file to public;
grant delete on xmh_file to public;
grant insert on xmh_file to public;