/*
================================================================================
档案代号:bni_file
档案名称:保税BOM编号档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bni_file
(
bni01       varchar2(20) NOT NULL,   /*BOM编号字首                            */
bni02       varchar2(4) NOT NULL,    /*BOM编号流水号                          */
bni03       varchar2(4) NOT NULL     /*BOM编号字尾                            */
);

create unique index bni_pk on bni_file (bni01,bni02,bni03);
alter table bni_file add  constraint bni_pk primary key  (bni01,bni02,bni03) enable validate;
grant select on bni_file to public;
grant index on bni_file to public;
grant update on bni_file to public;
grant delete on bni_file to public;
grant insert on bni_file to public;