/* ================================================================================ 档案代号: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; |