/*
================================================================================
档案代号:cad_file
档案名称:每月人工制费明细资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cad_file
(
cad01       number(5) NOT NULL,      /*年度                                   */
cad02       number(5) NOT NULL,      /*月份                                   */
cad03       varchar2(10) NOT NULL,   /*成本中心                               */
cad04       varchar2(10) NOT NULL,   /*成本项目                               */
cad05       varchar2(1),             /*成本分类 1.人工成本 2.制费             */
cad06       varchar2(24) NOT NULL,   /*会计科目                               */
cad07       varchar2(1),             /*固定/变动别(F/V)                       */
cad08       number(20,6)             /*本月投入成本                           */
);

create unique index cad_pk on cad_file (cad01,cad02,cad03,cad04,cad06);
alter table cad_file add  constraint cad_pk primary key  (cad01,cad02,cad03,cad04,cad06) enable validate;
grant select on cad_file to public;
grant index on cad_file to public;
grant update on cad_file to public;
grant delete on cad_file to public;
grant insert on cad_file to public;