/*
================================================================================
档案代号:dma_file
档案名称:类别代码档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table dma_file
(
dma01       varchar2(6) NOT NULL,    /*类别代码                               */
dma02       varchar2(80),            /*类别说明                               */
dmaacti     varchar2(1),             /*资料有效码                             */
dmauser     varchar2(10),            /*资料所有者                             */
dmagrup     varchar2(10),            /*资料所有群                             */
dmamodu     varchar2(10),            /*资料更改者                             */
dmadate     date                     /*最近修改日                             */
);

create unique index dma_pk on dma_file (dma01);
alter table dma_file add  constraint dma_pk primary key  (dma01) enable validate;
grant select on dma_file to public;
grant index on dma_file to public;
grant update on dma_file to public;
grant delete on dma_file to public;
grant insert on dma_file to public;