/*
================================================================================
档案代号:obs_file
档案名称:车辆厂牌档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table obs_file
(
obs01       varchar2(16) NOT NULL,   /*车辆厂牌                               */
obs02       varchar2(80),            /*说明                                   */
obsacti     varchar2(1),             /*资料有效码                             */
obsuser     varchar2(10),            /*资料所有者                             */
obsgrup     varchar2(10),            /*资料所有部门                           */
obsmodu     varchar2(10),            /*资料修改者                             */
obsdate     date                     /*最近修改日                             */
);

create unique index obs_pk on obs_file (obs01);
alter table obs_file add  constraint obs_pk primary key  (obs01) enable validate;
grant select on obs_file to public;
grant index on obs_file to public;
grant update on obs_file to public;
grant delete on obs_file to public;
grant insert on obs_file to public;