/*
================================================================================
档案代号:csf_file
档案名称:附加成本--料件分群码资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table csf_file
(
csf01       varchar2(10) NOT NULL,   /*料件分群码                             */
csf02       varchar2(10) NOT NULL,   /*成本项目                               */
csf03       varchar2(1),             /*成本归类                               */
csf04       number(9,4),             /*比率%                                  */
csf05       number(20,6)             /*金额                                   */
);

create unique index csf_pk on csf_file (csf01,csf02);
alter table csf_file add  constraint csf_pk primary key  (csf01,csf02) enable validate;
grant select on csf_file to public;
grant index on csf_file to public;
grant update on csf_file to public;
grant delete on csf_file to public;
grant insert on csf_file to public;