/*
================================================================================
档案代号:boi_file
档案名称:缩放比率参数档
档案目的:缩放比率参数档 单档多栏
上游档案:
下游档案:
============.========================.==========================================
*/
create table boi_file
(
boi01       varchar2(10) DEFAULT '' NOT NULL, /*参数代号*/
boi02       number(15,3) DEFAULT '0' NOT NULL, /*参数内容*/
boi03       varchar2(20) DEFAULT '' NOT NULL, /*参数描述*/
boiacti     varchar2(1) DEFAULT '' NOT NULL /*有效否*/
);

create unique index boi_pk on boi_file (boi01);
alter table boi_file add  constraint boi_pk primary key  (boi01) enable validate;
grant select on boi_file to public;
grant index on boi_file to public;
grant update on boi_file to public;
grant delete on boi_file to public;
grant insert on boi_file to public;