/*
================================================================================
档案代号:cai_file
档案名称:成本项目成本分析资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cai_file
(
cai01       varchar2(40) NOT NULL,   /*工单单号重覆性生产产品成本             */
cai02       number(5) NOT NULL,      /*年度                                   */
cai03       number(5) NOT NULL,      /*月份                                   */
cai04       varchar2(40),            /*主件料号                               */
                                     /*需存在在料件基本资料主档               */
                                     /*为该工单生产料件编号                   */
cai05       varchar2(10) NOT NULL,   /*成本中心                               */
cai06       varchar2(10) NOT NULL,   /*成本项目                               */
cai07       number(20,6)             /*本月投入金额                           */
);

create unique index cai_pk on cai_file (cai01,cai02,cai03,cai05,cai06);
alter table cai_file add  constraint cai_pk primary key  (cai01,cai02,cai03,cai05,cai06) enable validate;
grant select on cai_file to public;
grant index on cai_file to public;
grant update on cai_file to public;
grant delete on cai_file to public;
grant insert on cai_file to public;