/*
================================================================================
档案代号:oza_file
档案名称:航运基本代码档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oza_file
(
oza01       varchar2(10) NOT NULL,   /*航运代码                               */
oza02       varchar2(80),            /*航运说明                               */
ozaacti     varchar2(1),             /*资料有效码                             */
ozauser     varchar2(10),            /*资料所有者                             */
ozagrup     varchar2(10),            /*资料所有部门                           */
ozamodu     varchar2(10),            /*资料修改者                             */
ozadate     date                     /*最近修改日                             */
);

create unique index oza_pk on oza_file (oza01);
alter table oza_file add  constraint oza_pk primary key  (oza01) enable validate;
grant select on oza_file to public;
grant index on oza_file to public;
grant update on oza_file to public;
grant delete on oza_file to public;
grant insert on oza_file to public;