/* ================================================================================ 档案代号:vim_file 档案名称:vip类种单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vim_file ( vim01 varchar2(10) NOT NULL, /*VIP种类编号 */ vim02 varchar2(80), /*说明 */ vim03 number(15,6), /*折扣率% */ vimacti varchar2(1), /*资料有效码 */ vimdate date, /*最近修改日 */ vimgrup varchar2(10), /*资料所有部门 */ vimmodu varchar2(10), /*资料修改者 */ vimuser varchar2(10) /*资料所有者 */ ); create unique index vim_pk on vim_file (vim01); alter table vim_file add constraint vim_pk primary key (vim01) enable validate; grant select on vim_file to public; grant index on vim_file to public; grant update on vim_file to public; grant delete on vim_file to public; grant insert on vim_file to public; |