/*
================================================================================
档案代号:cak_file
档案名称:产品别成本项目设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cak_file
(
cak01       varchar2(10) NOT NULL,   /*产品分类                               */
                                     /*产品分类 -> ima131                     */
cak02       varchar2(10) NOT NULL,   /*成本中心                               */
cak03       varchar2(10) NOT NULL    /*成本项目                               */
);

create        index cak_01 on cak_file (cak01);
create        index cak_02 on cak_file (cak02,cak03);
create unique index cak_pk on cak_file (cak01,cak02,cak03);
alter table cak_file add  constraint cak_pk primary key  (cak01,cak02,cak03) enable validate;
grant select on cak_file to public;
grant index on cak_file to public;
grant update on cak_file to public;
grant delete on cak_file to public;
grant insert on cak_file to public;