/* ================================================================================ 档案代号:vas_file 档案名称:aps(顾客) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vas_file ( vas01 varchar2(10) DEFAULT '' NOT NULL, /*客户代号*/ vas02 varchar2(10) DEFAULT '' NOT NULL, /*客户群组代号*/ vas03 varchar2(40), /*客户名称 */ vas04 varchar2(10) /*客户群组名称 */ ); create unique index vas_pk on vas_file (vas01,vas02); alter table vas_file add constraint vas_pk primary key (vas01,vas02) enable validate; grant select on vas_file to public; grant index on vas_file to public; grant update on vas_file to public; grant delete on vas_file to public; grant insert on vas_file to public; |