/*
================================================================================
档案代号:vij_file
档案名称:vip积分使用规则单身--赠品档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vij_file
(
vij01       varchar2(10) NOT NULL,   /*积分使用规则编码                       */
vij02       number(5) NOT NULL,      /*项次                                   */
vij03       varchar2(40),            /*料件编号                               */
vij04       number(10)               /*所需积分                               */
);

create unique index vij_pk on vij_file (vij01,vij02);
alter table vij_file add  constraint vij_pk primary key  (vij01,vij02) enable validate;
grant select on vij_file to public;
grant index on vij_file to public;
grant update on vij_file to public;
grant delete on vij_file to public;
grant insert on vij_file to public;