/*
================================================================================
档案代号:mai_file
档案名称:报表结构单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table mai_file
(
mai01       varchar2(6) NOT NULL,    /*报表编号                               */
mai02       varchar2(80),            /*报表名称                               */
mai03       varchar2(1),             /*报表性质                               */
                                     /*报表性质(1/2/3/4)                      */
                                     /* 1:Trial Balance                       */
                                     /* 2:Balance Sheet                       */
                                     /* 3:Income Statement                    */
                                     /* 4:OTHER                               */
maiacti     varchar2(1),             /*资料有效码                             */
maiuser     varchar2(10),            /*资料所有者                             */
maigrup     varchar2(10),            /*资料所有部门                           */
maimodu     varchar2(10),            /*资料修改者                             */
maidate     date,                    /*最近修改日                             */
mai00       varchar2(5)              /*帐别                                   */
);

create unique index mai_pk on mai_file (mai01);
alter table mai_file add  constraint mai_pk primary key  (mai01) enable validate;
grant select on mai_file to public;
grant index on mai_file to public;
grant update on mai_file to public;
grant delete on mai_file to public;
grant insert on mai_file to public;