/*
================================================================================
档案代号:bmz_file
档案名称:工程变异单主件档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bmz_file
(
bmz01       varchar2(16) NOT NULL,   /*ECN.单号                               */
bmz02       varchar2(40) NOT NULL,   /*主件料件编号                           */
bmz03       varchar2(10),            /*版本                                   */
bmz04       varchar2(10),            /*原版本                                 */
bmz05       varchar2(20) NOT NULL    /*特性代码                               */
                                     /*No use                                 */
);

create unique index bmz_pk on bmz_file (bmz01,bmz02,bmz05);
alter table bmz_file add  constraint bmz_pk primary key  (bmz01,bmz02,bmz05) enable validate;
grant select on bmz_file to public;
grant index on bmz_file to public;
grant update on bmz_file to public;
grant delete on bmz_file to public;
grant insert on bmz_file to public;