/*
================================================================================
档案代号:vin_file
档案名称:vip类种单身档--for记录积分规则
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vin_file
(
vin01       varchar2(10) NOT NULL,   /*VIP种类编号                            */
vin02       number(5) NOT NULL,      /*项次                                   */
vin03       varchar2(10),            /*积分规则编码                           */
vinacti     varchar2(1)              /*资料有效码                             */
);

create unique index vin_pk on vin_file (vin01,vin02);
alter table vin_file add  constraint vin_pk primary key  (vin01,vin02) enable validate;
grant select on vin_file to public;
grant index on vin_file to public;
grant update on vin_file to public;
grant delete on vin_file to public;
grant insert on vin_file to public;