/*
================================================================================
档案代号:ocb_file
档案名称:关系人可冲销之厂商编号
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ocb_file
(
ocb01       varchar2(10) NOT NULL,   /*客户编号                               */
ocb02       varchar2(10) NOT NULL,   /*营运中心编号                           */
ocb03       varchar2(10) NOT NULL,   /*厂商编号                               */
ocb04       varchar2(1),             /*No Use                                 */
ocb05       varchar2(1),             /*No Use                                 */
ocbacti     varchar2(1),             /*资料有效码                             */
ocbuser     varchar2(10),            /*资料所有者                             */
ocbgrup     varchar2(10),            /*资料所有部门                           */
ocbmodu     varchar2(10),            /*资料修改者                             */
ocbdate     date                     /*最近修改日                             */
);

create unique index ocb_pk on ocb_file (ocb01,ocb02,ocb03);
alter table ocb_file add  constraint ocb_pk primary key  (ocb01,ocb02,ocb03) enable validate;
grant select on ocb_file to public;
grant index on ocb_file to public;
grant update on ocb_file to public;
grant delete on ocb_file to public;
grant insert on ocb_file to public;