/*
================================================================================
档案代号:mla_file
档案名称:报表转发人员单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table mla_file
(
mla01       varchar2(10) NOT NULL,   /*报表代号                               */
mla02       varchar2(4),             /*优先等级                               */
mla03       number(5),               /*查阅完成天数                           */
mlaacti     varchar2(1),             /*资料有效码                             */
mlauser     varchar2(10),            /*资料所有者                             */
mlagrup     varchar2(10),            /*资料所有部门                           */
mlamodu     varchar2(10),            /*资料修改者                             */
mladate     date                     /*最近修改日                             */
);

create unique index mla_pk on mla_file (mla01);
alter table mla_file add  constraint mla_pk primary key  (mla01) enable validate;
grant select on mla_file to public;
grant index on mla_file to public;
grant update on mla_file to public;
grant delete on mla_file to public;
grant insert on mla_file to public;