/*
================================================================================
档案代号:aya_file
档案名称:股东权益分类设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aya_file
(
aya01       varchar2(10) NOT NULL,   /*分类代码                               */
aya02       varchar2(80),            /*代码说明                               */
aya03       varchar2(1),             /*no use                                 */
aya04       varchar2(1),             /*no use                                 */
aya05       varchar2(1)              /*no use                                 */
);

create unique index aya_pk on aya_file (aya01);
alter table aya_file add  constraint aya_pk primary key  (aya01) enable validate;
grant select on aya_file to public;
grant index on aya_file to public;
grant update on aya_file to public;
grant delete on aya_file to public;
grant insert on aya_file to public;