/*
================================================================================
档案代号:ofq_file
档案名称:潜在客户来源资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ofq_file
(
ofq01       varchar2(4) NOT NULL,    /*潜在客户来源                           */
ofq02       varchar2(255),           /*说明                                   */
ofqacti     varchar2(1),             /*资料有效码                             */
ofquser     varchar2(10),            /*资料所有者                             */
ofqgrup     varchar2(10),            /*资料所有群                             */
ofqmodu     varchar2(10),            /*资料更改者                             */
ofqdate     date                     /*最近修改日                             */
);

create unique index ofq_pk on ofq_file (ofq01);
alter table ofq_file add  constraint ofq_pk primary key  (ofq01) enable validate;
grant select on ofq_file to public;
grant index on ofq_file to public;
grant update on ofq_file to public;
grant delete on ofq_file to public;
grant insert on ofq_file to public;