/*
================================================================================
档案代号:iml_file
档案名称:料件成本项目结构资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table iml_file
(
iml01       varchar2(40) NOT NULL,   /*料件编号                               */
iml02       varchar2(10) NOT NULL,   /*成本项目                               */
iml031      number(20,6),            /*标准成本                               */
iml032      number(20,6),            /*现时成本                               */
iml033      number(20,6)             /*预设成本                               */
);

create unique index iml_pk on iml_file (iml01,iml02);
alter table iml_file add  constraint iml_pk primary key  (iml01,iml02) enable validate;
grant select on iml_file to public;
grant index on iml_file to public;
grant update on iml_file to public;
grant delete on iml_file to public;
grant insert on iml_file to public;