/*
================================================================================
档案代号:vir_file
档案名称:vip积分使用情况档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vir_file
(
vir01       varchar2(16) NOT NULL,   /*VIP卡号                                */
vir02       date,                    /*使用日期                               */
vir03       varchar2(1),             /*使用方式                               */
vir04       varchar2(40),            /*赠品料号                               */
vir05       number(15,3)             /*数量                                   */
);

create        index vir_01 on vir_file (vir01);
grant select on vir_file to public;
grant index on vir_file to public;
grant update on vir_file to public;
grant delete on vir_file to public;
grant insert on vir_file to public;