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