/*
================================================================================
档案代号:aae_file
档案名称:科目分类名称档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aae_file
(
aae01       varchar2(10) NOT NULL,   /*科目分类编号                           */
aae02       varchar2(80),            /*科目分类名称                           */
aae03       varchar2(255),           /*备注                                   */
aaeacti     varchar2(1),             /*资料有效码                             */
                                     /*系统维护                               */
aaeuser     varchar2(10),            /*资料所有者                             */
                                     /*系统维护                               */
aaegrup     varchar2(10),            /*资料所有群                             */
                                     /*系统维护                               */
aaemodu     varchar2(10),            /*资料更改者                             */
                                     /*系统维护                               */
aaedate     date                     /*最近修改日                             */
                                     /*系统维护                               */
);

create unique index aae_pk on aae_file (aae01);
alter table aae_file add  constraint aae_pk primary key  (aae01) enable validate;
grant select on aae_file to public;
grant index on aae_file to public;
grant update on aae_file to public;
grant delete on aae_file to public;
grant insert on aae_file to public;