/*
================================================================================
档案代号:ccn_file
档案名称:标准BOM元件单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ccn_file
(
ccn01       varchar2(40) NOT NULL,   /*主件料号                               */
ccn02       varchar2(10) NOT NULL,   /*标准成本版本                           */
ccn03       number(5) NOT NULL,      /*项次                                   */
ccn04       varchar2(40),            /*元件料号                               */
ccn05       number(16,8),            /*标准 QPA                               */
ccn06       number(9,4),             /*损耗率                                 */
ccndate     date                     /*最近修改日期                           */
);

create unique index ccn_pk on ccn_file (ccn01,ccn02,ccn03);
alter table ccn_file add  constraint ccn_pk primary key  (ccn01,ccn02,ccn03) enable validate;
grant select on ccn_file to public;
grant index on ccn_file to public;
grant update on ccn_file to public;
grant delete on ccn_file to public;
grant insert on ccn_file to public;