/*
================================================================================
档案代号:ocd_file
档案名称:客户其它地址档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ocd_file
(
ocd01       varchar2(10) NOT NULL,   /*客户编号                               */
ocd02       varchar2(10) NOT NULL,   /*客户地址                               */
ocd03       varchar2(80),            /*说明                                   */
ocd04       varchar2(10),            /*邮递区号                               */
ocd221      varchar2(255),           /*地址-1                                 */
ocd222      varchar2(255),           /*地址-2                                 */
ocd223      varchar2(255),           /*地址-3                                 */
ocd224      varchar2(40),            /*电话-1                                 */
ocd225      varchar2(40),            /*电话-2                                 */
ocd226      varchar2(40),            /*传真-1                                 */
ocd227      varchar2(40),            /*传真-2                                 */
ocd228      varchar2(40),            /*联络人-1                               */
ocd229      varchar2(40),            /*联络人-2                               */
ocd230      varchar2(255),           /*地址-4                                 */
ocd231      varchar2(255)            /*地址-5                                 */
);

create unique index ocd_pk on ocd_file (ocd01,ocd02);
alter table ocd_file add  constraint ocd_pk primary key  (ocd01,ocd02) enable validate;
grant select on ocd_file to public;
grant index on ocd_file to public;
grant update on ocd_file to public;
grant delete on ocd_file to public;
grant insert on ocd_file to public;