/*
================================================================================
档案代号:bmw_file
档案名称:ECN 插件位置维护
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bmw_file
(
bmw01       varchar2(16) NOT NULL,   /*ECN 单号                               */
bmw02       number(5) NOT NULL,      /*项次                                   */
bmw03       number(5) NOT NULL,      /*行序                                   */
bmw04       varchar2(10),            /*插件位置                               */
bmw05       number(15,3)             /*插件位置数量                           */
);

create unique index bmw_pk on bmw_file (bmw01,bmw02,bmw03);
alter table bmw_file add  constraint bmw_pk primary key  (bmw01,bmw02,bmw03) enable validate;
grant select on bmw_file to public;
grant index on bmw_file to public;
grant update on bmw_file to public;
grant delete on bmw_file to public;
grant insert on bmw_file to public;