/* ================================================================================ 档案代号: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; |