/*
================================================================================
档案代号:bol_file
档案名称:部位基本资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bol_file
(
bol01       varchar2(10) DEFAULT '' NOT NULL, /*部位代码*/
bol02       varchar2(80) DEFAULT '' NOT NULL, /*部位说明*/
bol03       varchar2(80) DEFAULT '' NOT NULL, /*英文说明*/
bol04       varchar2(1) DEFAULT '' NOT NULL, /*部位性质 1-横 2-直*/
bolacti     varchar2(1) DEFAULT '' NOT NULL /*有效否*/
);

create unique index bol_pk on bol_file (bol01);
alter table bol_file add  constraint bol_pk primary key  (bol01) enable validate;
grant select on bol_file to public;
grant index on bol_file to public;
grant update on bol_file to public;
grant delete on bol_file to public;
grant insert on bol_file to public;