/*
================================================================================
档案代号:ozb_file
档案名称:航运基本代码档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ozb_file
(
ozb01       varchar2(10) NOT NULL,   /*海运代码                               */
ozb02       varchar2(80),            /*海运说明                               */
ozbacti     varchar2(1),             /*资料有效码                             */
ozbuser     varchar2(10),            /*资料所有者                             */
ozbgrup     varchar2(10),            /*资料所有部门                           */
ozbmodu     varchar2(10),            /*资料修改者                             */
ozbdate     date                     /*最近修改日                             */
);

create unique index ozb_pk on ozb_file (ozb01);
alter table ozb_file add  constraint ozb_pk primary key  (ozb01) enable validate;
grant select on ozb_file to public;
grant index on ozb_file to public;
grant update on ozb_file to public;
grant delete on ozb_file to public;
grant insert on ozb_file to public;