/*
================================================================================
档案代号:occg_file
档案名称:客户信用额度GLOBAL档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table occg_file
(
occg01      varchar2(10) NOT NULL,   /*客户编号                               */
occg02      varchar2(20),            /*统一编号                               */
occg03      number(20,6),            /*信用额度额度                           */
occg04      number(5)                /*信用额度容许超出率                     */
);

create        index occg_02 on occg_file (occg02);
create unique index occg_pk on occg_file (occg01);
alter table occg_file add  constraint occg_pk primary key  (occg01) enable validate;
grant select on occg_file to public;
grant index on occg_file to public;
grant update on occg_file to public;
grant delete on occg_file to public;
grant insert on occg_file to public;