/* ================================================================================ 档案代号:obb_file 档案名称:产品大类档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table obb_file ( obb01 varchar2(1) NOT NULL, /*产品大类码 */ obb02 varchar2(80), /*大类名称 */ obb03 varchar2(1), /*No Use */ obb04 varchar2(1), /*No Use */ obb05 varchar2(1), /*No Use */ obb06 varchar2(1) /*No Use */ ); create unique index obb_pk on obb_file (obb01); alter table obb_file add constraint obb_pk primary key (obb01) enable validate; grant select on obb_file to public; grant index on obb_file to public; grant update on obb_file to public; grant delete on obb_file to public; grant insert on obb_file to public; |