/*
================================================================================
档案代号:ccx_file
档案名称:每月工单投入数量设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ccx_file
(
ccx01       varchar2(16) NOT NULL,   /*工单编号                               */
ccx02       number(5) NOT NULL,      /*年度                                   */
ccx03       number(5) NOT NULL,      /*月份                                   */
ccx04       number(15,3) NOT NULL    /*本月投入数量                           */
);

create unique index ccx_pk on ccx_file (ccx01,ccx02,ccx03);
alter table ccx_file add  constraint ccx_pk primary key  (ccx01,ccx02,ccx03) enable validate;
grant select on ccx_file to public;
grant index on ccx_file to public;
grant update on ccx_file to public;
grant delete on ccx_file to public;
grant insert on ccx_file to public;