/*
================================================================================
档案代号:afa_file
档案名称:预算名称档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table afa_file
(
afa00       varchar2(5) NOT NULL,    /*帐别编号                               */
                                     /*帐别编号 ----> no use 1998/10/21       */
afa01       varchar2(10) NOT NULL,   /*预算编号                               */
afa02       varchar2(80),            /*预算名称                               */
afaacti     varchar2(1),             /*资料有效码                             */
afauser     varchar2(10),            /*资料所有者                             */
afagrup     varchar2(10),            /*资料所有群                             */
afamodu     varchar2(10),            /*资料更改者                             */
afadate     date                     /*最近修改日                             */
);

create unique index afa_pk on afa_file (afa00,afa01);
alter table afa_file add  constraint afa_pk primary key  (afa00,afa01) enable validate;
grant select on afa_file to public;
grant index on afa_file to public;
grant update on afa_file to public;
grant delete on afa_file to public;
grant insert on afa_file to public;