/*
================================================================================
档案代号:cxz_file
档案名称:工单成本项目资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cxz_file
(
cxz01       varchar2(40) NOT NULL,   /*工单单号重覆性生产产品成本             */
cxz02       varchar2(10) NOT NULL,   /*成本中心                               */
cxz03       varchar2(10) NOT NULL,   /*成本项目                               */
cxz04       number(20,6),            /*人工总成本                             */
cxz05       number(20,6),            /*制费总成本                             */
cxz06       number(15,3),            /*人工指标总数                           */
cxz07       number(15,3)             /*制费指标总数                           */
);

create unique index cxz_pk on cxz_file (cxz01,cxz02,cxz03);
alter table cxz_file add  constraint cxz_pk primary key  (cxz01,cxz02,cxz03) enable validate;
grant select on cxz_file to public;
grant index on cxz_file to public;
grant update on cxz_file to public;
grant delete on cxz_file to public;
grant insert on cxz_file to public;