/*
================================================================================
档案代号:std_file
档案名称:成本系统参数档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table std_file
(
std00       varchar2(1),             /*KEY VALUE                              */
                                     /*KEY : '0'                              */
std01       number(5) NOT NULL,      /*成本系统关帐年度                       */
std02       number(5)                /*成本系统关帐月份                       */
);

create unique index std_pk on std_file (std01);
alter table std_file add  constraint std_pk primary key  (std01) enable validate;
grant select on std_file to public;
grant index on std_file to public;
grant update on std_file to public;
grant delete on std_file to public;
grant insert on std_file to public;