/* ================================================================================ 档案代号:vbh_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table vbh_file ( vbh01 varchar2(10) DEFAULT '' NOT NULL, /*外包商代号*/ vbh02 varchar2(40) DEFAULT '' NOT NULL, /*外包商名称*/ vbh03 varchar2(40) /*外包部描述 */ ); create unique index vbh_pk on vbh_file (vbh01); alter table vbh_file add constraint vbh_pk primary key (vbh01) enable validate; grant select on vbh_file to public; grant index on vbh_file to public; grant update on vbh_file to public; grant delete on vbh_file to public; grant insert on vbh_file to public; |