/*
================================================================================
档案代号:obq_file
档案名称:车辆类型档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table obq_file
(
obq01       varchar2(4) NOT NULL,    /*车辆类型                               */
obq02       varchar2(80),            /*说明                                   */
obqacti     varchar2(1),             /*资料有效码                             */
obquser     varchar2(10),            /*资料所有者                             */
obqgrup     varchar2(10),            /*资料所有部门                           */
obqmodu     varchar2(10),            /*资料修改者                             */
obqdate     date                     /*最近修改日                             */
);

create unique index obq_pk on obq_file (obq01);
alter table obq_file add  constraint obq_pk primary key  (obq01) enable validate;
grant select on obq_file to public;
grant index on obq_file to public;
grant update on obq_file to public;
grant delete on obq_file to public;
grant insert on obq_file to public;