/*
================================================================================
档案代号:odh_file
档案名称:预测模拟单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table odh_file
(
odh01       varchar2(10) NOT NULL,   /*预测版本                               */
odh02       varchar2(10) NOT NULL,   /*组织代号                               */
odh03       varchar2(40) NOT NULL,   /*预测料号                               */
odh04       date NOT NULL,           /*时距                                   */
odh05       number(15,3),            /*模拟数量                               */
odh06       number(20,6),            /*模拟金额                               */
odh07       number(15,3),            /*基准数量                               */
odh08       number(20,6),            /*基准金额                               */
odh09       date                     /*基准时距                               */
);

create unique index odh_pk on odh_file (odh01,odh02,odh03,odh04);
alter table odh_file add  constraint odh_pk primary key  (odh01,odh02,odh03,odh04) enable validate;
grant select on odh_file to public;
grant index on odh_file to public;
grant update on odh_file to public;
grant delete on odh_file to public;
grant insert on odh_file to public;