/*
================================================================================
档案代号:aak_file
档案名称:会计科目额外说明档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aak_file
(
aak01       varchar2(24) NOT NULL,   /*科目编号                               */
aak02       varchar2(4) NOT NULL,    /*类别                                   */
aak03       number(5) NOT NULL,      /*行序                                   */
aak04       varchar2(80),            /*额外说明                               */
aak00       varchar2(5) NOT NULL     /*帐别                                   */
);

create unique index aak_pk on aak_file (aak00,aak01,aak02,aak03);
alter table aak_file add  constraint aak_pk primary key  (aak00,aak01,aak02,aak03) enable validate;
grant select on aak_file to public;
grant index on aak_file to public;
grant update on aak_file to public;
grant delete on aak_file to public;
grant insert on aak_file to public;