/* ================================================================================ 档案代号: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; |