/*
================================================================================
档案代号:ocj_file
档案名称:客户往来银行资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ocj_file
(
ocj01       varchar2(10) NOT NULL,   /*客户编号                               */
ocj02       varchar2(11) NOT NULL,   /*银行代号                               */
ocj03       varchar2(30) NOT NULL,   /*银行帐号                               */
ocjacti     varchar2(1),             /*资料有效码                             */
ocj04       varchar2(80),            /*帐号名称                               */
ocj05       varchar2(1)              /*是否主要帐号                           */
);

create unique index ocj_pk on ocj_file (ocj01,ocj02,ocj03);
alter table ocj_file add  constraint ocj_pk primary key  (ocj01,ocj02,ocj03) enable validate;
grant select on ocj_file to public;
grant index on ocj_file to public;
grant update on ocj_file to public;
grant delete on ocj_file to public;
grant insert on ocj_file to public;