/*
================================================================================
档案代号:cac_file
档案名称:成本项目分摊系数资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cac_file
(
cac01       varchar2(10) NOT NULL,   /*成本中心                               */
cac02       varchar2(10) NOT NULL,   /*成本项目                               */
cac03       number(15,3)             /*分摊系数                               */
);

create unique index cac_pk on cac_file (cac01,cac02);
alter table cac_file add  constraint cac_pk primary key  (cac01,cac02) enable validate;
grant select on cac_file to public;
grant index on cac_file to public;
grant update on cac_file to public;
grant delete on cac_file to public;
grant insert on cac_file to public;