/*
================================================================================
档案代号:dmb_file
档案名称:版本代码档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table dmb_file
(
dmb01       varchar2(6) NOT NULL,    /*版本代码                               */
dmb02       varchar2(80),            /*版本说明                               */
dmbacti     varchar2(1),             /*资料有效码                             */
dmbuser     varchar2(10),            /*资料所有者                             */
dmbgrup     varchar2(10),            /*资料所有群                             */
dmbmodu     varchar2(10),            /*资料更改者                             */
dmbdate     date                     /*最近修改日                             */
);

create unique index dmb_pk on dmb_file (dmb01);
alter table dmb_file add  constraint dmb_pk primary key  (dmb01) enable validate;
grant select on dmb_file to public;
grant index on dmb_file to public;
grant update on dmb_file to public;
grant delete on dmb_file to public;
grant insert on dmb_file to public;