/* ================================================================================ 档案代号:obl_file 档案名称:产品客户包装档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table obl_file ( obl01 varchar2(40) NOT NULL, /*产品编号 */ obl02 varchar2(10) NOT NULL, /*客户编号 */ obl03 varchar2(15) /*包装方式 */ ); create unique index obl_pk on obl_file (obl01,obl02); alter table obl_file add constraint obl_pk primary key (obl01,obl02) enable validate; grant select on obl_file to public; grant index on obl_file to public; grant update on obl_file to public; grant delete on obl_file to public; grant insert on obl_file to public; |