/*
================================================================================
档案代号:stm_file
档案名称:生产量值统计档--By 产品别
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table stm_file
(
stm01       number(5) NOT NULL,      /*年度                                   */
stm02       number(5) NOT NULL,      /*月份                                   */
stm03       varchar2(10) NOT NULL,   /*产品别                                 */
stm04       number(15,3),            /*生产数量                               */
stm05       number(20,6),            /*生产成本                               */
stm06       number(15,3),            /*生产数量                               */
                                     /*生产数量(不含重工)                     */
stm07       number(20,6)             /*生产成本                               */
                                     /*生产成本(不含重工)                     */
);

create unique index stm_pk on stm_file (stm01,stm02,stm03);
alter table stm_file add  constraint stm_pk primary key  (stm01,stm02,stm03) enable validate;
grant select on stm_file to public;
grant index on stm_file to public;
grant update on stm_file to public;
grant delete on stm_file to public;
grant insert on stm_file to public;