/*
================================================================================
档案代号:ccm_file
档案名称:标准BOM主件单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ccm_file
(
ccm01       varchar2(40) NOT NULL,   /*主件料号                               */
ccm02       varchar2(10) NOT NULL,   /*标准成本版本                           */
ccm03       number(5),               /*标准工时                               */
ccm04       number(5),               /*No Use                                 */
ccm05       number(5),               /*No Use                                 */
ccm06       number(5),               /*No Use                                 */
ccmuser     varchar2(10),            /*资料所有者                             */
ccmgrup     varchar2(10),            /*资料GROUP                              */
ccmmodd     date,                    /*最近修改日                             */
ccmdate     date                     /*最近成本卷算日                         */
);

create unique index ccm_pk on ccm_file (ccm01,ccm02);
alter table ccm_file add  constraint ccm_pk primary key  (ccm01,ccm02) enable validate;
grant select on ccm_file to public;
grant index on ccm_file to public;
grant update on ccm_file to public;
grant delete on ccm_file to public;
grant insert on ccm_file to public;