/*
================================================================================
档案代号:cdb_file
档案名称:每月人工/制费档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cdb_file
(
cdb01       number(5) DEFAULT '0' NOT NULL, /*年度*/
cdb02       number(5) DEFAULT '0' NOT NULL, /*月份*/
cdb03       varchar2(10) DEFAULT '' NOT NULL, /*成本中心*/
cdb04       varchar2(10) DEFAULT '' NOT NULL, /*成本项目*/
cdb05       number(15,3) DEFAULT '0' NOT NULL, /*成本*/
cdb06       number(15,3) DEFAULT '0' NOT NULL, /*分摊基础指标总数*/
cdb07       number(15,6) DEFAULT '0' NOT NULL, /*单位成本*/
cdb08       varchar2(1) DEFAULT '' NOT NULL, /*分摊方式*/
cdbdate     date,                    /*最近修改日                             */
cdbgrup     varchar2(10),            /*资料所有部门                           */
cdbmodu     varchar2(10),            /*资料修改者                             */
cdbuser     varchar2(10)             /*资料所有者                             */
);

create unique index cdb_pk on cdb_file (cdb01,cdb02,cdb03,cdb04,cdb08);
alter table cdb_file add  constraint cdb_pk primary key  (cdb01,cdb02,cdb03,cdb04,cdb08) enable validate;
grant select on cdb_file to public;
grant index on cdb_file to public;
grant update on cdb_file to public;
grant delete on cdb_file to public;
grant insert on cdb_file to public;