/*
================================================================================
档案代号:pns_file
档案名称:请采购预算单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pns_file
(
pns01       varchar2(10) NOT NULL,   /*预算编号                               */
pns02       varchar2(24) NOT NULL,   /*科目编号                               */
pns03       varchar2(10) NOT NULL,   /*部门编号                               */
pns04       number(5) NOT NULL,      /*年度                                   */
pns05       number(5) NOT NULL,      /*月份                                   */
pns06       number(20,6),            /*原始预算金额                           */
pns07       number(20,6),            /*追加金额                               */
pns08       number(20,6),            /*挪用金额                               */
pns09       number(20,6)             /*月预算金额                             */
);

create unique index pns_pk on pns_file (pns01,pns02,pns03,pns04,pns05);
alter table pns_file add  constraint pns_pk primary key  (pns01,pns02,pns03,pns04,pns05) enable validate;
grant select on pns_file to public;
grant index on pns_file to public;
grant update on pns_file to public;
grant delete on pns_file to public;
grant insert on pns_file to public;