/*
================================================================================
档案代号:ozg_file
档案名称:其他运输基本代码档
档案目的:记录其他运输基本资料
上游档案:
下游档案:
============.========================.==========================================
*/
create table ozg_file
(
ozg01       varchar2(10) NOT NULL,
ozg02       varchar2(60),
ozgacti     varchar2(1),             /*资料有效码                             */
ozguser     varchar2(10),
ozggrup     varchar2(6),
ozgmodu     varchar2(10),
ozgdate     date
);

create unique index ozg_pk on ozg_file (ozg01);
alter table ozg_file add  constraint ozg_pk primary key  (ozg01) enable validate;
grant select on ozg_file to public;
grant index on ozg_file to public;
grant update on ozg_file to public;
grant delete on ozg_file to public;
grant insert on ozg_file to public;