/*
================================================================================
档案代号:afe_file
档案名称:预算底稿单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table afe_file
(
afe00       varchar2(10) DEFAULT '' NOT NULL, /*预算版本*/
afe01       varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/
afe02       number(5) DEFAULT '0' NOT NULL, /*预算年度*/
afe03       varchar2(10) DEFAULT '' NOT NULL, /*预算部门*/
afe04       varchar2(10) DEFAULT '' NOT NULL, /*专案代号*/
afe05       varchar2(30) DEFAULT '' NOT NULL, /*wbs编码*/
afe06       varchar2(6) DEFAULT '' NOT NULL, /*预算项目*/
afe07       varchar2(24) DEFAULT '' NOT NULL, /*会计科目*/
afe08       number(5) DEFAULT '0' NOT NULL, /*期别*/
afe09       number(20,6),            /*预算金额                               */
afe10       number(20,6),            /*调整金额                               */
afe11       number(20,6),            /*预算金额(来源)                         */
afe12       number(20,6)             /*预算金额(来源)                         */
);

create unique index afe_pk on afe_file (afe00,afe01,afe02,afe03,afe04,afe05,afe06,afe07,afe08);
alter table afe_file add  constraint afe_pk primary key  
(afe00,afe01,afe02,afe03,afe04,afe05,afe06,afe07,afe08) enable validate;
grant select on afe_file to public;
grant index on afe_file to public;
grant update on afe_file to public;
grant delete on afe_file to public;
grant insert on afe_file to public;