/* ================================================================================ 档案代号:obf_file 档案名称:产品价格单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table obf_file ( obf01 varchar2(10) NOT NULL, /*产品分类 */ /*产品分类 (必须输入分类编号或'*') */ obf02 varchar2(40) NOT NULL /*产品编号 */ /*产品编号 (必须输入产品编号或'*') */ ); create unique index obf_pk on obf_file (obf01,obf02); alter table obf_file add constraint obf_pk primary key (obf01,obf02) enable validate; grant select on obf_file to public; grant index on obf_file to public; grant update on obf_file to public; grant delete on obf_file to public; grant insert on obf_file to public; |