/*
================================================================================
档案代号:obv_file
档案名称:车辆保养群组档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table obv_file
(
obv01       varchar2(4) NOT NULL,    /*保养群组                               */
obv012      varchar2(80),            /*说明                                   */
obv02       number(5) NOT NULL,      /*项次                                   */
obv03       varchar2(4),             /*保养项目                               */
obvacti     varchar2(1),             /*资料有效码                             */
obvuser     varchar2(10),            /*资料所有者                             */
obvgrup     varchar2(10),            /*资料所有部门                           */
obvmodu     varchar2(10),            /*资料修改者                             */
obvdate     date,                    /*最近修改日                             */
obv04       number(10),              /*里程公里数                             */
obv05       number(5)                /*行驶年数                               */
);

create unique index obv_pk on obv_file (obv01,obv02);
alter table obv_file add  constraint obv_pk primary key  (obv01,obv02) enable validate;
grant select on obv_file to public;
grant index on obv_file to public;
grant update on obv_file to public;
grant delete on obv_file to public;
grant insert on obv_file to public;