/*
================================================================================
档案代号:cdc_file
档案名称:每月工单人工/制费档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cdc_file
(
cdc01       number(5) DEFAULT '0' NOT NULL, /*年度*/
cdc02       number(5) DEFAULT '0' NOT NULL, /*月份*/
cdc03       varchar2(10) DEFAULT '' NOT NULL, /*成本中心*/
cdc04       varchar2(10) DEFAULT '' NOT NULL, /*成本项目*/
cdc041      varchar2(16) DEFAULT '' NOT NULL, /*工单编号*/
cdc05       number(15,3) DEFAULT '0' NOT NULL, /*成本*/
cdc06       number(15,3) DEFAULT '0' NOT NULL, /*分摊基础指标总数*/
cdc07       number(15,6) DEFAULT '0' NOT NULL, /*单位成本*/
cdc08       varchar2(1) DEFAULT '' NOT NULL, /*分摊方式*/
cdcdate     date,                    /*最近修改日                             */
cdcgrup     varchar2(10),            /*资料所有部门                           */
cdcmodu     varchar2(10),            /*资料修改者                             */
cdcuser     varchar2(10)             /*资料所有者                             */
);

create unique index cdc_pk on cdc_file (cdc01,cdc02,cdc03,cdc04,cdc041,cdc08);
alter table cdc_file add  constraint cdc_pk primary key  (cdc01,cdc02,cdc03,cdc04,cdc041,cdc08) enable 
validate;
grant select on cdc_file to public;
grant index on cdc_file to public;
grant update on cdc_file to public;
grant delete on cdc_file to public;
grant insert on cdc_file to public;