/*
================================================================================
档案代号:ayb_file
档案名称:股东权益分类对应会计科目档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ayb_file
(
ayb01       varchar2(10) NOT NULL,   /*分类代码                               */
ayb02       varchar2(24) NOT NULL,   /*会计科目                               */
ayb03       varchar2(1),             /*no use                                 */
ayb04       varchar2(255)            /*no use                                 */
);

create unique index ayb_pk on ayb_file (ayb01,ayb02);
alter table ayb_file add  constraint ayb_pk primary key  (ayb01,ayb02) enable validate;
grant select on ayb_file to public;
grant index on ayb_file to public;
grant update on ayb_file to public;
grant delete on ayb_file to public;
grant insert on ayb_file to public;