/*
================================================================================
档案代号:bms_file
档案名称:设计变更申请说明资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bms_file
(
bms01       varchar2(16) NOT NULL,   /*设计变更申请单号                       */
bms02       number(5) NOT NULL,      /*行序                                   */
                                     /*储存工程变异申请说明行序，可作为显示时 */
                                     /*的顺序。                               */
bms03       varchar2(255)            /*说明                                   */
                                     /*储存工程变异申请说明。                 */
);

create unique index bms_pk on bms_file (bms01,bms02);
alter table bms_file add  constraint bms_pk primary key  (bms01,bms02) enable validate;
grant select on bms_file to public;
grant index on bms_file to public;
grant update on bms_file to public;
grant delete on bms_file to public;
grant insert on bms_file to public;