/*
================================================================================
档案代号:aea_file
档案名称:分类帐档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aea_file
(
aea00       varchar2(5) NOT NULL,    /*帐别                                   */
aea01       varchar2(24) NOT NULL,   /*统治或独立科目编号                     */
aea02       date,                    /*传票日期                               */
aea03       varchar2(16) NOT NULL,   /*传票编号                               */
aea04       number(5) NOT NULL,      /*项次                                   */
aea05       varchar2(24)             /*明细科目编号                           */
);

create        index aea_01 on aea_file (aea01,aea02);
create        index aea_02 on aea_file (aea05,aea02);
create unique index aea_pk on aea_file (aea03,aea04,aea01,aea00);
alter table aea_file add  constraint aea_pk primary key  (aea03,aea04,aea01,aea00) enable validate;
grant select on aea_file to public;
grant index on aea_file to public;
grant update on aea_file to public;
grant delete on aea_file to public;
grant insert on aea_file to public;