/* ================================================================================ 档案代号: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; |