/*
================================================================================
档案代号:con_file
档案名称:合同标准BOM单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table con_file
(
con01       varchar2(40) NOT NULL,   /*商品编号                               */
con012      varchar2(1),             /*No Use                                 */
con013      varchar2(20) NOT NULL,   /*版本编号                               */
                                     /*版本编号          NO.A087              */
con02       number(5),               /*项次                                   */
con03       varchar2(40) NOT NULL,   /*商品编号                               */
con032      varchar2(1),             /*No Use                                 */
con04       varchar2(4),             /*单位                                   */
con05       number(16,8),            /*单耗                                   */
con06       number(9,5),             /*损耗率                                 */
con07       varchar2(10),            /*原产国                                 */
con08       varchar2(10) NOT NULL,   /*海关代号                               */
                                     /*No:BUG-490398                          */
con09       varchar2(1),             /*No Use                                 */
con10       varchar2(1)              /*No Use                                 */
);

create unique index con_pk on con_file (con01,con013,con08,con03);
alter table con_file add  constraint con_pk primary key  (con01,con013,con08,con03) enable validate;
grant select on con_file to public;
grant index on con_file to public;
grant update on con_file to public;
grant delete on con_file to public;
grant insert on con_file to public;