/*
================================================================================
档案代号:occm_file
档案名称:杂项客户主档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table occm_file
(
occm01      varchar2(16) NOT NULL,   /*订单编号                               */
occm02      varchar2(20),            /*统一编号                               */
occm03      varchar2(80),            /*公司全名一                             */
occm031     varchar2(80),            /*公司全名二                             */
                                     /*公司全名二  add 01/12/27               */
occm04      varchar2(255),           /*发票地址                               */
occm05      varchar2(255),           /*发票地址                               */
occm06      varchar2(255),           /*发票地址                               */
occm07      varchar2(255),           /*发票地址-4                             */
occm08      varchar2(255)            /*发票地址-5                             */
);

create        index occm_02 on occm_file (occm02);
create unique index occm_pk on occm_file (occm01);
alter table occm_file add  constraint occm_pk primary key  (occm01) enable validate;
grant select on occm_file to public;
grant index on occm_file to public;
grant update on occm_file to public;
grant delete on occm_file to public;
grant insert on occm_file to public;