/*
================================================================================
档案代号:ccp_file
档案名称:各月份使用标准成本版本设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ccp_file
(
ccp01       number(5) NOT NULL,      /*年度                                   */
ccp02       number(5) NOT NULL,      /*月份                                   */
ccp03       varchar2(10)             /*标准成本版本                           */
);

create unique index ccp_pk on ccp_file (ccp01,ccp02);
alter table ccp_file add  constraint ccp_pk primary key  (ccp01,ccp02) enable validate;
grant select on ccp_file to public;
grant index on ccp_file to public;
grant update on ccp_file to public;
grant delete on ccp_file to public;
grant insert on ccp_file to public;