/*
================================================================================
档案代号:obm_file
档案名称:运输方式档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table obm_file
(
obm01       varchar2(10) NOT NULL,   /*运输方式代码                           */
obm02       varchar2(80),            /*说明                                   */
obmacti     varchar2(1),             /*有效否                                 */
obmuser     varchar2(10),            /*建档人员                               */
obmgrup     varchar2(10),            /*建档部门                               */
obmmodu     varchar2(10),            /*最后修改人员                           */
obmdate     date                     /*最后修改日期                           */
);

create unique index obm_pk on obm_file (obm01);
alter table obm_file add  constraint obm_pk primary key  (obm01) enable validate;
grant select on obm_file to public;
grant index on obm_file to public;
grant update on obm_file to public;
grant delete on obm_file to public;
grant insert on obm_file to public;