/*
================================================================================
档案代号:stn_file
档案名称:生产量值统计档--By 产品分类
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table stn_file
(
stn01       number(5) NOT NULL,      /*年度                                   */
stn02       number(5) NOT NULL,      /*月份                                   */
stn03       varchar2(10) NOT NULL,   /*产品分类                               */
stn04       number(15,3),            /*生产数量                               */
stn05       number(20,6),            /*生产成本                               */
stn06       number(15,3),            /*生产数量                               */
                                     /*生产数量(不含重工)                     */
stn07       number(20,6)             /*生产成本                               */
                                     /*生产成本(不含重工)                     */
);

create unique index stn_pk on stn_file (stn01,stn02,stn03);
alter table stn_file add  constraint stn_pk primary key  (stn01,stn02,stn03) enable validate;
grant select on stn_file to public;
grant index on stn_file to public;
grant update on stn_file to public;
grant delete on stn_file to public;
grant insert on stn_file to public;