/*
================================================================================
档案代号:aab_file
档案名称:科目部门设限档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aab_file
(
aab01       varchar2(24) NOT NULL,   /*科目编号                               */
aab02       varchar2(10) NOT NULL,   /*部门编号                               */
                                     /*部门编号 (拒绝接受的部门)              */
aab03       varchar2(255),           /*备注                                   */
aab00       varchar2(5) NOT NULL     /*帐别                                   */
);

create unique index aab_pk on aab_file (aab00,aab01,aab02);
alter table aab_file add  constraint aab_pk primary key  (aab00,aab01,aab02) enable validate;
grant select on aab_file to public;
grant index on aab_file to public;
grant update on aab_file to public;
grant delete on aab_file to public;
grant insert on aab_file to public;