/*
================================================================================
档案代号:axl_file
档案名称:股东权益群组表
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table axl_file
(
axl01       varchar2(10) NOT NULL,   /*群组代码                               */
axl02       varchar2(80),            /*说明                                   */
axl03       varchar2(1),             /*No Use                                 */
                                     /*变动分类                               */
                                     /*1.股本 2.资本公积 3.法定盈余公积       */
                                     /*4.未分配盈余 5.累积换算调整数          */
                                     /*6.未认列退休金成本之净损失             */
                                     /*7.少数股权                             */
axl04       varchar2(1),             /*No Use                                 */
axl05       varchar2(1),             /*No Use                                 */
axl06       varchar2(1),             /*No Use                                 */
axl07       varchar2(1),             /*No Use                                 */
axl08       varchar2(1)              /*No Use                                 */
);

create unique index axl_pk on axl_file (axl01);
alter table axl_file add  constraint axl_pk primary key  (axl01) enable validate;
grant select on axl_file to public;
grant index on axl_file to public;
grant update on axl_file to public;
grant delete on axl_file to public;
grant insert on axl_file to public;