/*
================================================================================
档案代号:oce_file
档案名称:客户联络人档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oce_file
(
oce01       varchar2(10) NOT NULL,   /*客户编号                               */
oce02       varchar2(40),            /*职务                                   */
oce03       varchar2(40) NOT NULL,   /*联络人                                 */
oce04       varchar2(40),            /*联络电话                               */
oce05       varchar2(80),            /*E-mail address                         */
oce06       date,                    /*No Use                                 */
oce07       varchar2(40),            /*住宅号码                               */
oce08       varchar2(40),            /*传真号码                               */
oce09       varchar2(255),           /*身份证地址                             */
oce10       varchar2(20)             /*身份证号码                             */
);

create unique index oce_pk on oce_file (oce01,oce03);
alter table oce_file add  constraint oce_pk primary key  (oce01,oce03) enable validate;
grant select on oce_file to public;
grant index on oce_file to public;
grant update on oce_file to public;
grant delete on oce_file to public;
grant insert on oce_file to public;