/*
================================================================================
档案代号:com_file
档案名称:合同标准BOM单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table com_file
(
com01       varchar2(40) NOT NULL,   /*商品编号                               */
com012      varchar2(1),             /*No Use                                 */
com02       varchar2(20) NOT NULL,   /*版本编号                               */
                                     /*版本编号         NO.A087               */
com03       varchar2(10) NOT NULL,   /*海关代号                               */
                                     /*海关代号         No:BUG-490398         */
com04       varchar2(1),             /*No Use                                 */
com05       varchar2(1),             /*No Use                                 */
comacti     varchar2(1),             /*资料有效码                             */
comuser     varchar2(10),            /*资料所有者                             */
comgrup     varchar2(10),            /*资料所有群                             */
commodu     varchar2(10),            /*资料更改者                             */
comdate     date                     /*最近修改日                             */
);

create unique index com_pk on com_file (com01,com02,com03);
alter table com_file add  constraint com_pk primary key  (com01,com02,com03) enable validate;
grant select on com_file to public;
grant index on com_file to public;
grant update on com_file to public;
grant delete on com_file to public;
grant insert on com_file to public;