/*
================================================================================
档案代号:vih_file
档案名称:vip积分规则档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vih_file
(
vih01       varchar2(10) NOT NULL,   /*积分规则编码                           */
vih02       varchar2(80),            /*积分规则名称                           */
vih03       date,                    /*生效日期                               */
vih04       date,                    /*失效日期                               */
vih05       number(10),              /*积分数                                 */
vih06       number(20,6),            /*消费金额                               */
vih07       varchar2(4),             /*币别                                   */
vihacti     varchar2(1),             /*资料有效码                             */
vihdate     date,                    /*最近修改日                             */
vihgrup     varchar2(10),            /*资料所有部门                           */
vihmodu     varchar2(10),            /*资料修改者                             */
vihuser     varchar2(10)             /*资料所有者                             */
);

create unique index vih_pk on vih_file (vih01);
alter table vih_file add  constraint vih_pk primary key  (vih01) enable validate;
grant select on vih_file to public;
grant index on vih_file to public;
grant update on vih_file to public;
grant delete on vih_file to public;
grant insert on vih_file to public;